111,094
社区成员




/// <summary>
/// 增加一条数据
/// </summary>
public bool Add()
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into [Material](");
strSql.Append("MaterialGuid,UpperLimit,LowerLimit,IConsultPrice,EConsultPrice,CalculateMethod,Remark,MaterialId,MaterialName,ClassId,Spec,Unit,BarNo,Place,Encapsulation,Photo");
strSql.Append(")");
strSql.Append(" values (");
strSql.Append("'"+MaterialGuid+"',");
strSql.Append(""+UpperLimit+",");
strSql.Append(""+LowerLimit+",");
strSql.Append(""+IConsultPrice+",");
strSql.Append(""+EConsultPrice+",");
strSql.Append("'"+CalculateMethod+"',");
strSql.Append("'"+Remark+"',");
strSql.Append("'"+MaterialId+"',");
strSql.Append("'"+MaterialName+"',");
strSql.Append("'"+ClassId+"',");
strSql.Append("'"+Spec+"',");
strSql.Append("'"+Unit+"',");
strSql.Append("'"+BarNo+"',");
strSql.Append("'"+Place+"',");
strSql.Append("'"+Encapsulation + "',");
byte[] photo_byte = null; //数据库存图片
using (FileStream fs = new FileStream(Photo, FileMode.Open, FileAccess.Read))
{
using (BinaryReader br = new BinaryReader(fs))
{
photo_byte = br.ReadBytes((int)fs.Length);
}
}
strSql.Append("'" + photo_byte + "'");
strSql.Append(")");
CommonInterface pComm = CommonFactory.CreateInstance(CommonData.sql);
try
{
pComm.Execute(strSql.ToString()); //执行Sql语句无返回值
pComm.Close();
return true;
}
catch (System.Exception e)
{
pComm.Close();
throw e;
}
}
以上是数据库添加类代码