public int UpdateStorage_details(EntityStorage_details entity, SearchParameter sp)
{ //设置更新库存表SQL语句
string SqlStr = "";
SqlStr = "update tc_storage_details";
SqlStr += " set storage_goods_code= '" + entity.Storage_goods_code.Trim();
SqlStr += "' ,storage_count=" + entity.Storage_count + ",storage_inputdate='" + entity.Storage_inputdate + "',storage_maker_code= '" + entity.Storage_maker_code.Trim() + "',storage_count_name='" + entity.Storage_count_name.Trim() + "'";
ArrayList arrayList = sp.Keys();
switch (sp.GetHashTable[arrayList[0]].GetType().Name)
{
case "String":
SqlStr += " where " + arrayList[0].ToString().Replace(":", "") + " like '" + sp.GetValue(arrayList[0].ToString()) + "%'";
break;
case "Int32":
SqlStr += " where " + arrayList[0].ToString().Replace(":", "") + "= " + sp.GetValue(arrayList[0].ToString()) + "";
break;
default:
SqlStr += " where " + arrayList[0].ToString().Replace(":", "") + " like '" + sp.GetValue(arrayList[0].ToString()) + "%'";
break;
}
SqlCommand sqlCommand = new SqlCommand();
sqlCommand.CommandText = SqlStr;
//执行SQL语句
ExcuteSql(sqlCommand);
//返回操作成功结果
return(Constants.SystemConfig.SERVER_SUCCESS);
}
public int InsertStorage_detailsRow(EntityStorage_details entity)
{ //设置插入库存表SQL语句
string SqlStr = "";
SqlStr = "insert into tc_storage_details";
SqlStr += " values('" + entity.Storage_code.Trim() + "','" + entity.Storage_input_code.Trim() + "','" + entity.Storage_goods_code.Trim() + "'," + entity.Storage_count;
SqlStr += ",'" + entity.Storage_inputdate + "','" + entity.Storage_maker_code.Trim() + "','" + entity.Storage_count_name.Trim() + "')";
SqlCommand sqlCommand = new SqlCommand();
sqlCommand.CommandText = SqlStr;
//执行SQL语句
ExcuteSql(sqlCommand);
//返回操作成功结果
return(Constants.SystemConfig.SERVER_SUCCESS);
}
