/// <summary>
/// 添加供应商档案的sql语句
/// </summary>
/// <param name="listSql"></param>
/// <param name="partID"></param>
private void AddWareHouseSqlString(List <SysSQLString> listSql, string whId)
{
SysSQLString sysStringSql = new SysSQLString();
sysStringSql.cmdType = CommandType.Text;
Dictionary <string, string> dicParam = new Dictionary <string, string>();//参数
tb_warehouse model = new tb_warehouse();
CommonFuncCall.SetModelObjectValue(this, model);
model.wh_id = whId;
int datasorces = (int)SYSModel.DataSources.EnumDataSources.SELFBUILD;//1自建，2宇通
model.data_source = datasorces.ToString();
int StatusNum = (int)SYSModel.DataSources.EnumStatus.Start;//0停用，1启用
model.status = StatusNum.ToString();
model.enable_flag = "1";
model.create_by = GlobalStaticObj.UserID;
model.create_time = Common.LocalDateTimeToUtcLong(DateTime.Now);
model.com_id = txtChooseCompanty.Tag == null ? "" : txtChooseCompanty.Tag.ToString();
model.wh_head = txtChooseWhHead.Text;
if (model != null)
{
StringBuilder sb = new StringBuilder();
sb.Append(" Insert Into tb_warehouse( ");
StringBuilder sp = new StringBuilder();
StringBuilder sb_prame = new StringBuilder();
foreach (PropertyInfo info in model.GetType().GetProperties())
{
string name = info.Name;
object value = info.GetValue(model, null);
sb_prame.Append("," + name);
sp.Append(",@" + name);
dicParam.Add(name, value == null ? "" : value.ToString());
}
sb.Append(sb_prame.ToString().Substring(1, sb_prame.ToString().Length - 1) + ") Values (");
sb.Append(sp.ToString().Substring(1, sp.ToString().Length - 1) + ")").Append(";");
sysStringSql.sqlString = sb.ToString();
sysStringSql.Param = dicParam;
listSql.Add(sysStringSql);
}
}
/// <summary>
/// 编辑供应商档案的sql语句
/// </summary>
/// <param name="listSql"></param>
/// <param name="supID"></param>
/// <param name="model"></param>
private void EditWareHouseSqlString(List <SysSQLString> listSql, string whId, tb_warehouse model)
{
SysSQLString sysStringSql = new SysSQLString();
sysStringSql.cmdType = CommandType.Text;
Dictionary <string, string> dicParam = new Dictionary <string, string>();//参数
CommonFuncCall.SetModelObjectValue(this, model);
model.update_by = GlobalStaticObj.UserID;
model.update_time = Common.LocalDateTimeToUtcLong(DateTime.Now);
model.com_id = txtChooseCompanty.Tag == null ? "" : txtChooseCompanty.Tag.ToString();
model.wh_head = txtChooseWhHead.Text;
if (model != null)
{
StringBuilder sb = new StringBuilder();
sb.Append(" Update tb_warehouse Set ");
bool isFirstValue = true;
foreach (PropertyInfo info in model.GetType().GetProperties())
{
string name = info.Name;
object value = info.GetValue(model, null);
if (isFirstValue)
{
isFirstValue = false;
sb.Append(name);
sb.Append("=");
sb.Append("@" + name);
}
else
{
sb.Append("," + name);
sb.Append("=");
sb.Append("@" + name);
}
dicParam.Add(name, value == null ? "" : value.ToString());
}
sb.Append(" where wh_id='" + whId + "';");
sysStringSql.sqlString = sb.ToString();
sysStringSql.Param = dicParam;
listSql.Add(sysStringSql);
}
}