/// <summary>
/// 加载仓库档案信息
/// </summary>
private void LoadInfo(string wareHouseId)
{
if (!string.IsNullOrEmpty(wareHouseId))
{
//1.加载仓库档案主信息
DataTable dt = DBHelper.GetTable("查看一条仓库档案信息", "v_warehouse_companyname_username", "*", " wh_id='" + wareHouseId + "'", "", "");
if (dt != null && dt.Rows.Count > 0)
{
tb_warehouse tb_warehouse_Model = new tb_warehouse();
CommonFuncCall.SetModlByDataTable(tb_warehouse_Model, dt);
CommonFuncCall.SetShowControlValue(this, tb_warehouse_Model, "View");
lblcom_id.Text = dt.Rows[0]["com_name"].ToString();
DataSources.EnumDataSources enumDataSources = (DataSources.EnumDataSources)Convert.ToInt16(tb_warehouse_Model.data_source);
lbldata_source.Text = DataSources.GetDescription(enumDataSources, true);
if (!string.IsNullOrEmpty(tb_warehouse_Model.county))
{
lblwh_address.Text = CommonFuncCall.GetAddress(tb_warehouse_Model.county) + " " + lblwh_address.Text;
}
else
{
if (!string.IsNullOrEmpty(tb_warehouse_Model.city))
{
lblwh_address.Text = CommonFuncCall.GetAddress(tb_warehouse_Model.city) + " " + lblwh_address.Text;
}
else
{
if (!string.IsNullOrEmpty(tb_warehouse_Model.province))
{
lblwh_address.Text = CommonFuncCall.GetAddress(tb_warehouse_Model.province) + " " + lblwh_address.Text;
}
}
}
}
}
}
/// <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);
}
}
/// <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);
}
}
