/// <summary>
/// 修改品牌信息
/// </summary>
/// <param name="unitInfo"></param>
/// <param name="pTran"></param>
/// <returns></returns>
private bool SetUnitBrandUpdate(UnitInfo unitInfo, IDbTransaction pTran)
{
PublicService pService = new PublicService();
#region
string sql = "update StoreBrandMapping set IsDelete = '0' ";
sql = pService.GetIsNotNullUpdateSql(sql, "LastUpdateBy", unitInfo.Modify_User_Id);
sql = pService.GetIsNotNullUpdateSql(sql, "LastUpdateTime", unitInfo.Modify_Time);
sql = sql + " From ( ";
int i = 0;
foreach (var itemBrandInfo in unitInfo.ItemBrandList)
{
if (i != 0)
{
sql = sql + " union all ";
}
sql = sql + "select '" + unitInfo.Id + "' StoreId "
+ ",'" + itemBrandInfo.MappingId + "' MappingId "
+ ",'" + itemBrandInfo.BrandId + "' BrandId ";
i++;
}
sql = sql + " ) a, StoreBrandMapping x where ( x.BrandId = a.BrandId and x.StoreId = a.StoreId) or (x.BrandId = a.BrandId)";
#endregion
if (pTran != null)
{
this.SQLHelper.ExecuteNonQuery((SqlTransaction)pTran, CommandType.Text, sql.ToString(), null);
}
else
{
this.SQLHelper.ExecuteNonQuery(sql);
}
return(true);
}
/// <summary>
/// 修改商品属性
/// </summary>
/// <param name="itemInfo"></param>
/// <param name="pTran"></param>
/// <returns></returns>
private bool SetItemPropUpdate(ItemInfo itemInfo, IDbTransaction pTran)
{
PublicService pService = new PublicService();
#region
string sql = "update t_item_property set status = '1' ,prop_value = a.prop_value";
sql = pService.GetIsNotNullUpdateSql(sql, "modify_user_id", itemInfo.Modify_User_Id);
sql = pService.GetIsNotNullUpdateSql(sql, "modify_time", itemInfo.Modify_Time);
sql = sql + " From ( ";
int i = 0;
foreach (ItemPropInfo itemPropInfo in itemInfo.ItemPropList)
{
if (i != 0)
{
sql = sql + " union all ";
}
sql = sql + "select '" + itemInfo.Item_Id + "' item_id "
+ ",'" + itemPropInfo.PropertyCodeId + "' prop_id "
+ ",'" + itemPropInfo.Item_Property_Id + "' item_property_id "
+ ",'" + itemPropInfo.PropertyCodeValue + "' prop_value ";
i++;
}
sql = sql + " ) a where ( t_item_property.item_id = a.item_id and t_item_property.prop_id = a.prop_id ) or (t_item_property.item_property_id = a.item_property_id)";
#endregion
if (pTran != null)
{
this.SQLHelper.ExecuteNonQuery((SqlTransaction)pTran, CommandType.Text, sql.ToString(), null);
}
else
{
this.SQLHelper.ExecuteNonQuery(sql);
}
return(true);
}
/// <summary>
/// 修改角色与菜单关系
/// </summary>
/// <param name="roleInfo"></param>
/// <param name="pTran"></param>
/// <returns></returns>
private bool SetRoleMenuUpdate(RoleModel roleInfo, IDbTransaction pTran)
{
PublicService pService = new PublicService();
#region
string sql = "update T_Role_Menu set status = '1'";
sql = pService.GetIsNotNullUpdateSql(sql, "modify_user_id", roleInfo.Create_User_Id);
sql = pService.GetIsNotNullUpdateSql(sql, "modify_time", roleInfo.Create_Time);
sql = sql + " From ( ";
int i = 0;
foreach (RoleMenuModel roleMenuRole in roleInfo.RoleMenuInfoList)
{
if (i != 0)
{
sql = sql + " union all ";
}
sql = sql + "select '" + roleInfo.Role_Id + "' role_id "
+ ",'" + roleMenuRole.Menu_Id + "' Menu_Id ";
i++;
}
sql = sql + " ) a where ( T_Role_Menu.role_id = a.role_id and T_Role_Menu.menu_id = a.menu_id)";
#endregion
if (pTran != null)
{
this.SQLHelper.ExecuteNonQuery((SqlTransaction)pTran, CommandType.Text, sql.ToString(), null);
}
else
{
this.SQLHelper.ExecuteNonQuery(sql);
}
return(true);
}
/// <summary>
/// 更新角色
/// </summary>
/// <param name="roleInfo"></param>
/// <param name="pTran"></param>
/// <returns></returns>
private bool SetRoleUpdate(RoleModel roleInfo, IDbTransaction pTran)
{
PublicService pService = new PublicService();
#region
string sql = "update t_role set def_app_id = '" + roleInfo.Def_App_Id + "' ";
sql = pService.GetIsNotNullUpdateSql(sql, "Role_Code", roleInfo.Role_Code);
sql = pService.GetIsNotNullUpdateSql(sql, "Role_Name", roleInfo.Role_Name);
sql = pService.GetIsNotNullUpdateSql(sql, "Role_Eng_Name", roleInfo.Role_Eng_Name);
sql = pService.GetIsNotNullUpdateSql(sql, "Is_Sys", roleInfo.Is_Sys.ToString());
sql = pService.GetIsNotNullUpdateSql(sql, "Modify_Time", roleInfo.Modify_Time);
sql = pService.GetIsNotNullUpdateSql(sql, "Modify_User_id", roleInfo.Modify_User_id);
sql = pService.GetIsNotNullUpdateSql(sql, "type_id", roleInfo.type_id);
sql = pService.GetIsNotNullUpdateSql(sql, "org_level", roleInfo.org_level.ToString());
sql = sql + " where role_id = '" + roleInfo.Role_Id + "' ;";
#endregion
if (pTran != null)
{
this.SQLHelper.ExecuteNonQuery((SqlTransaction)pTran, CommandType.Text, sql.ToString(), null);
}
else
{
this.SQLHelper.ExecuteNonQuery(sql);
}
return(true);
}
/// <summary>
/// 修改出入库单据状态
/// </summary>
/// <param name="ccInfo"></param>
/// <returns></returns>
public bool SetCCStatusUpdate(CCInfo ccInfo)
{
string sql = "update T_CC set [status] = '" + ccInfo.status + "' ,status_desc = '" + ccInfo.status_desc + "'"
+ " ,Modify_Time = '" + ccInfo.modify_time + "' ,Modify_User_Id = '" + ccInfo.modify_user_id + "' ";
PublicService pService = new PublicService();
sql = pService.GetIsNotNullUpdateSql(sql, "approve_user_id", ccInfo.approve_user_id);
sql = pService.GetIsNotNullUpdateSql(sql, "approve_time", ccInfo.approve_time);
sql = sql + " ,if_flag = '0' where order_id = '" + ccInfo.order_id + "'";
this.SQLHelper.ExecuteNonQuery(sql);
return(true);
}
/// <summary>
/// 修改图片信息
/// </summary>
/// <param name="itemInfo"></param>
/// <param name="pTran"></param>
/// <returns></returns>
private bool SetItemImageUpdate(ItemInfo itemInfo, IDbTransaction pTran)
{
PublicService pService = new PublicService();
#region
string sql = "update ObjectImages set IsDelete = '0' ,ImageURL = a.ImageURL, DisplayIndex = a.DisplayIndex, Title = a.Title, Description = a.Description ";
sql = pService.GetIsNotNullUpdateSql(sql, "LastUpdateBy", itemInfo.Modify_User_Id);
sql = pService.GetIsNotNullUpdateSql(sql, "LastUpdateTime", itemInfo.Modify_Time);
sql = sql + " From ( ";
int i = 0;
foreach (var itemImageInfo in itemInfo.ItemImageList)
{
if (i != 0)
{
sql = sql + " union all ";
}
sql = sql + "select '" + itemInfo.Item_Id + "' ObjectId "
+ ",'" + itemImageInfo.ImageURL + "' ImageURL "
+ ",'" + (itemImageInfo.DisplayIndex + 1) + "' DisplayIndex " //让DisplayIndex+1了
+ ",'" + itemImageInfo.Title + "' Title "
+ ",'" + itemImageInfo.Description + "' Description "
+ ",'" + itemImageInfo.ImageId + "' ImageId "
;
i++;
}
sql = sql + " ) a, ObjectImages x where (x.ImageId = a.ImageId)";
// ---( x.ObjectId = a.ObjectId and x.ImageURL = a.ImageURL and x.DisplayIndex = a.DisplayIndex) or
#endregion
if (pTran != null)
{
this.SQLHelper.ExecuteNonQuery((SqlTransaction)pTran, CommandType.Text, sql.ToString(), null);
}
else
{
this.SQLHelper.ExecuteNonQuery(sql);
}
return(true);
}
/// <summary>
/// 删除品牌信息
/// </summary>
/// <param name="unitInfo"></param>
/// <param name="pTran"></param>
/// <returns></returns>
private bool SetUnitBrandStatus(UnitInfo unitInfo, IDbTransaction pTran)
{
PublicService pService = new PublicService();
#region
string sql = "update StoreBrandMapping set IsDelete = '1' ";
sql = pService.GetIsNotNullUpdateSql(sql, "LastUpdateBy", unitInfo.Modify_User_Id);
sql = pService.GetIsNotNullUpdateSql(sql, "LastUpdateTime", unitInfo.Modify_Time);
sql = sql + " where StoreId = '" + unitInfo.Id + "' ";
#endregion
if (pTran != null)
{
this.SQLHelper.ExecuteNonQuery((SqlTransaction)pTran, CommandType.Text, sql.ToString(), null);
}
else
{
this.SQLHelper.ExecuteNonQuery(sql);
}
return(true);
}
/// <summary>
/// 删除角色与菜单关系
/// </summary>
/// <param name="roleInfo"></param>
/// <param name="pTran"></param>
/// <returns></returns>
private bool SetRoleMenuStatus(RoleModel roleInfo, IDbTransaction pTran)
{
PublicService pService = new PublicService();
#region
string sql = "update T_Role_Menu set status = '-1' ";
sql = pService.GetIsNotNullUpdateSql(sql, "modify_user_id", roleInfo.Create_User_Id);
sql = pService.GetIsNotNullUpdateSql(sql, "modify_time", roleInfo.Create_Time);
sql = sql + " where role_id = '" + roleInfo.Role_Id + "' ";
#endregion
if (pTran != null)
{
this.SQLHelper.ExecuteNonQuery((SqlTransaction)pTran, CommandType.Text, sql.ToString(), null);
}
else
{
this.SQLHelper.ExecuteNonQuery(sql);
}
return(true);
}
/// <summary>
/// 修改商品价格
/// </summary>
/// <param name="itemInfo"></param>
/// <param name="pTran"></param>
/// <returns></returns>
private bool SetItemPriceUpdate(ItemInfo itemInfo, IDbTransaction pTran)
{
PublicService pService = new PublicService();
#region
string sql = "update t_item_price set status = '1' ,item_price = a.item_price";
sql = pService.GetIsNotNullUpdateSql(sql, "modify_user_id", itemInfo.Modify_User_Id);
sql = pService.GetIsNotNullUpdateSql(sql, "modify_time", itemInfo.Modify_Time);
sql = pService.GetIsNotNullUpdateSql(sql, "if_flag", "0");
sql = sql + " From ( ";
int i = 0;
foreach (ItemPriceInfo itemPriceInfo in itemInfo.ItemPriceList)
{
if (i != 0)
{
sql = sql + " union all ";
}
sql = sql + "select '" + itemInfo.Item_Id + "' item_id "
+ ",'" + itemPriceInfo.item_price + "' item_price "
+ ",'" + itemPriceInfo.item_price_type_id + "' item_price_type_id "
+ ",'" + itemPriceInfo.item_price_id + "' item_price_id "
+ ",'" + this.loggingSessionInfo.CurrentLoggingManager.Customer_Id + "' customer_id ";
i++;
}
sql = sql + " ) a, t_item_price x where ( x.item_id = a.item_id and x.item_price_type_id = a.item_price_type_id and x.customer_id = a.customer_id) or (x.item_price_id = a.item_price_id)";
#endregion
if (pTran != null)
{
this.SQLHelper.ExecuteNonQuery((SqlTransaction)pTran, CommandType.Text, sql.ToString(), null);
}
else
{
this.SQLHelper.ExecuteNonQuery(sql);
}
return(true);
}
/// <summary>
/// 删除商品价格
/// </summary>
/// <param name="itemInfo"></param>
/// <param name="pTran"></param>
/// <returns></returns>
private bool SetItemPriceStatus(ItemInfo itemInfo, IDbTransaction pTran)
{
PublicService pService = new PublicService();
#region
string sql = "update t_item_price set status = '-1' ";
sql = pService.GetIsNotNullUpdateSql(sql, "modify_user_id", itemInfo.Modify_User_Id);
sql = pService.GetIsNotNullUpdateSql(sql, "modify_time", itemInfo.Modify_Time);
sql = pService.GetIsNotNullUpdateSql(sql, "if_flag", "0");
sql = sql + " where item_id = '" + itemInfo.Item_Id + "' and customer_id = '" + this.loggingSessionInfo.CurrentLoggingManager.Customer_Id.ToString() + "' ";
#endregion
if (pTran != null)
{
this.SQLHelper.ExecuteNonQuery((SqlTransaction)pTran, CommandType.Text, sql.ToString(), null);
}
else
{
this.SQLHelper.ExecuteNonQuery(sql);
}
return(true);
}
/// <summary>
/// 修改商品门店
/// </summary>
/// <param name="itemInfo"></param>
/// <param name="pTran"></param>
/// <returns></returns>
private bool SetItemUnitUpdate(ItemInfo itemInfo, IDbTransaction pTran)
{
PublicService pService = new PublicService();
#region
string sql = "update ItemStoreMapping set isDelete = '0' ";
sql = pService.GetIsNotNullUpdateSql(sql, "LastUpdateBy", itemInfo.Modify_User_Id);
sql = pService.GetIsNotNullUpdateSql(sql, "LastUpdateTime", itemInfo.Modify_Time);
//sql = pService.GetIsNotNullUpdateSql(sql, "if_flag", "0");
sql = sql + " From ( ";
int i = 0;
foreach (ItemStoreMappingEntity itemUnitInfo in itemInfo.ItemUnitList)
{
if (i != 0)
{
sql = sql + " union all ";
}
sql = sql + "select '" + itemInfo.Item_Id + "' itemId "
+ ",'" + itemUnitInfo.UnitId + "' UnitId "
+ ",'" + itemUnitInfo.MappingId + "' MappingId ";
//+ ",'" + this.loggingSessionInfo.CurrentLoggingManager.Customer_Id + "' customer_id ";
i++;
}
sql = sql + " ) a, ItemStoreMapping x where x.itemId = a.itemId and x.UnitId = a.UnitId"; // or (x.UnitId = a.UnitId)
#endregion
if (pTran != null)
{
this.SQLHelper.ExecuteNonQuery((SqlTransaction)pTran, CommandType.Text, sql.ToString(), null);
}
else
{
this.SQLHelper.ExecuteNonQuery(sql);
}
return(true);
}
/// <summary>
/// 提交盘点单据
/// </summary>
/// <param name="loggingSessionInfo"></param>
/// <param name="ccInfo">盘点单信息</param>
/// <returns></returns>
private bool SetCCTableInfo(CCInfo ccInfo)
{
PublicService pService = new PublicService();
string sql = "";
//修改盘点单主表
#region
sql = " update t_cc set order_no = '" + ccInfo.order_no + "' ";
sql = pService.GetIsNotNullUpdateSql(sql, "order_date", ccInfo.order_date);
sql = pService.GetIsNotNullUpdateSql(sql, "order_type_id", ccInfo.order_type_id);
sql = pService.GetIsNotNullUpdateSql(sql, "order_reason_id", ccInfo.order_reason_id);
sql = pService.GetIsNotNullUpdateSql(sql, "ref_order_id", ccInfo.ref_order_id);
sql = pService.GetIsNotNullUpdateSql(sql, "ref_order_no", ccInfo.ref_order_no);
sql = pService.GetIsNotNullUpdateSql(sql, "request_date", ccInfo.request_date);
sql = pService.GetIsNotNullUpdateSql(sql, "complete_date", ccInfo.complete_date);
sql = pService.GetIsNotNullUpdateSql(sql, "unit_id", ccInfo.unit_id);
sql = pService.GetIsNotNullUpdateSql(sql, "pos_id", ccInfo.pos_id);
sql = pService.GetIsNotNullUpdateSql(sql, "warehouse_id", ccInfo.warehouse_id);
sql = pService.GetIsNotNullUpdateSql(sql, "remark", ccInfo.remark);
sql = pService.GetIsNotNullUpdateSql(sql, "data_from_id", ccInfo.data_from_id);
sql = pService.GetIsNotNullUpdateSql(sql, "status", ccInfo.status);
sql = pService.GetIsNotNullUpdateSql(sql, "status_desc", ccInfo.status_desc);
sql = pService.GetIsNotNullUpdateSql(sql, "create_time", ccInfo.create_time);
sql = pService.GetIsNotNullUpdateSql(sql, "create_user_id", ccInfo.create_user_id);
sql = pService.GetIsNotNullUpdateSql(sql, "modify_time", ccInfo.modify_time);
sql = pService.GetIsNotNullUpdateSql(sql, "modify_user_id", ccInfo.modify_user_id);
sql = pService.GetIsNotNullUpdateSql(sql, "send_time", ccInfo.send_time);
sql = pService.GetIsNotNullUpdateSql(sql, "send_user_id", ccInfo.send_user_id);
sql = pService.GetIsNotNullUpdateSql(sql, "approve_time", ccInfo.approve_time);
sql = pService.GetIsNotNullUpdateSql(sql, "approve_user_id", ccInfo.approve_user_id);
sql = pService.GetIsNotNullUpdateSql(sql, "accpect_time", ccInfo.accpect_time);
sql = pService.GetIsNotNullUpdateSql(sql, "accpect_user_id", ccInfo.accpect_user_id);
sql = pService.GetIsNotNullUpdateSql(sql, "if_flag", ccInfo.if_flag);
sql = sql + " where order_id = '" + ccInfo.order_id + "' ; ";
#endregion
//插入盘点单
#region
sql = sql + "insert into t_cc( "
+ " order_id "
+ " ,order_no "
+ " ,order_date "
+ " ,order_type_id "
+ " ,order_reason_id "
+ " ,ref_order_id "
+ " ,ref_order_no "
+ " ,request_date "
+ " ,complete_date "
+ " ,unit_id "
+ " ,pos_id "
+ " ,warehouse_id "
+ " ,remark "
+ " ,data_from_id "
+ " ,status "
+ " ,status_desc "
+ " ,create_time "
+ " ,create_user_id "
+ " ,modify_time "
+ " ,modify_user_id "
+ " ,send_time "
+ " ,send_user_id "
+ " ,approve_time "
+ " ,approve_user_id "
+ " ,accpect_time "
+ " ,accpect_user_id "
+ " ,if_flag "
+ " ,customer_id "
+ " ) "
+ " select a.* From ( "
+ " select '" + ccInfo.order_id + "' order_id "
+ " ,'" + ccInfo.order_no + "' order_no "
+ " ,'" + ccInfo.order_date + "' order_date "
+ " ,'" + ccInfo.order_type_id + "' order_type_id "
+ " ,'" + ccInfo.order_reason_id + "' order_reason_id "
+ " ,'" + ccInfo.ref_order_id + "' ref_order_id "
+ " ,'" + ccInfo.ref_order_no + "' ref_order_no "
+ " ,'" + ccInfo.request_date + "' request_date "
+ " ,'" + ccInfo.complete_date + "' complete_date "
+ " ,'" + ccInfo.unit_id + "' unit_id "
+ " ,'" + ccInfo.pos_id + "' pos_id "
+ " ,'" + ccInfo.warehouse_id + "' warehouse_id "
+ " ,'" + ccInfo.remark + "' remark "
+ " ,'" + ccInfo.data_from_id + "' data_from_id "
+ " ,'" + ccInfo.status + "' status "
+ " ,'" + ccInfo.status_desc + "' status_desc "
+ " ,'" + ccInfo.create_time + "' create_time "
+ " ,'" + ccInfo.create_user_id + "' create_user_id "
+ " ,'" + ccInfo.modify_time + "' modify_time "
+ " ,'" + ccInfo.modify_user_id + "' modify_user_id "
+ " ,'" + ccInfo.send_time + "' send_time "
+ " ,'" + ccInfo.send_user_id + "' send_user_id "
+ " ,'" + ccInfo.approve_time + "' approve_time "
+ " ,'" + ccInfo.approve_user_id + "' approve_user_id "
+ " ,'" + ccInfo.accpect_time + "' accpect_time "
+ " ,'" + ccInfo.accpect_user_id + "' accpect_user_id "
+ " ,'" + ccInfo.if_flag + "' if_flag "
+ " ,'" + ccInfo.customer_id + "' customer_id "
+ " ) a "
+ " left join T_cc b "
+ " on(a.order_id = b.order_id) "
+ " where b.order_id is null ; ";
#endregion
//删除盘点单明细
#region
sql = sql + "delete t_cc_detail where order_id = '" + ccInfo.order_id + "' ;";
#endregion
//插入明细
if (ccInfo.CCDetailInfoList != null)
{
foreach (CCDetailInfo ccDetailInfo in ccInfo.CCDetailInfoList)
{
#region
sql = sql + "insert into t_cc_detail "
+ " ( "
+ " order_detail_id "
+ " ,order_id "
+ " ,ref_order_detail_id "
+ " ,order_no "
+ " ,stock_balance_id "
+ " ,sku_id "
+ " ,warehouse_id "
+ " ,end_qty "
+ " ,order_qty "
+ " ,remark "
+ " ,display_index "
+ " ,create_time "
+ " ,create_user_id "
+ " ,modify_time "
+ " ,modify_user_id "
+ " ,if_flag "
+ " ) "
+ " SELECT '" + ccDetailInfo.order_detail_id + "' order_detail_id "
+ " ,'" + ccDetailInfo.order_id + "' order_id "
+ " ,'" + ccDetailInfo.ref_order_detail_id + "' ref_order_detail_id "
+ " ,'" + ccDetailInfo.order_no + "' order_no "
+ " ,'" + ccDetailInfo.stock_balance_id + "' stock_balance_id "
+ " ,'" + ccDetailInfo.sku_id + "' sku_id "
+ " ,'" + ccDetailInfo.warehouse_id + "' warehouse_id "
+ " ,'" + ccDetailInfo.end_qty + "' end_qty "
+ " ,'" + ccDetailInfo.order_qty + "' order_qty "
+ " ,'" + ccDetailInfo.remark + "' remark "
+ " ,'" + ccDetailInfo.display_index + "' display_index "
+ " ,'" + ccDetailInfo.create_time + "' create_time "
+ " ,'" + ccDetailInfo.create_user_id + "' create_user_id "
+ " ,'" + ccDetailInfo.modify_time + "' modify_time "
+ " ,'" + ccDetailInfo.modify_user_id + "' modify_user_id "
+ " ,'" + ccDetailInfo.if_flag + "' if_flag ;";
#endregion
}
}
this.SQLHelper.ExecuteNonQuery(sql);
return(true);
}
/// <summary>
/// 更新出入库表主信息
/// </summary>
/// <param name="inoutInfo"></param>
/// <param name="pTran"></param>
private bool UpdateMenu(MenuModel userInfo, IDbTransaction pTran)
{
PublicService pService = new PublicService();
#region
string sql = "update t_menu set menu_code = '" + userInfo.Menu_Code + "' ";
sql = pService.GetIsNotNullUpdateSql(sql, "reg_app_id", userInfo.Reg_App_Id);
sql = pService.GetIsNotNullUpdateSql(sql, "parent_menu_id", userInfo.Parent_Menu_Id);
sql = pService.GetIsNotNullUpdateSql(sql, "menu_level", userInfo.Menu_Level.ToString());
sql = pService.GetIsNotNullUpdateSql(sql, "url_path", userInfo.Url_Path);
sql = pService.GetIsNotNullUpdateSql(sql, "icon_path", userInfo.Icon_Path);
sql = pService.GetIsNotNullUpdateSql(sql, "display_index", userInfo.Display_Index.ToString());
sql = pService.GetIsNotNullUpdateSql(sql, "menu_name", userInfo.Menu_Name);
sql = pService.GetIsNotNullUpdateSql(sql, "user_flag", userInfo.User_Flag.ToString());
sql = pService.GetIsNotNullUpdateSql(sql, "menu_eng_name", userInfo.Menu_Eng_Name);
sql = pService.GetIsNotNullUpdateSql(sql, "status", userInfo.Status.ToString());
sql = pService.GetIsNotNullUpdateSql(sql, "modify_user_id", userInfo.Create_User_Id);
sql = pService.GetIsNotNullUpdateSql(sql, "modify_time", System.DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));
sql = sql + " where menu_id = '" + userInfo.Menu_Id + "' ;";
#endregion
if (pTran != null)
{
this.SQLHelper.ExecuteNonQuery((SqlTransaction)pTran, CommandType.Text, sql.ToString(), null);
}
else
{
this.SQLHelper.ExecuteNonQuery(sql);
}
return(true);
}
/// <summary>
/// 更新出入库表主信息
/// </summary>
/// <param name="orderInfo"></param>
/// <param name="pTran"></param>
private bool UpdateOrder(OrderInfo orderInfo, IDbTransaction pTran)
{
PublicService pService = new PublicService();
#region
string sql = "update t_order set order_no = '" + orderInfo.order_no + "',if_flag = '" + orderInfo.if_flag + "' ";
sql = pService.GetIsNotNullUpdateSql(sql, "order_type_id", orderInfo.order_type_id);
sql = pService.GetIsNotNullUpdateSql(sql, "order_reason_type_id", orderInfo.order_reason_type_id);
sql = pService.GetIsNotNullUpdateSql(sql, "red_flag", orderInfo.red_flag);
sql = pService.GetIsNotNullUpdateSql(sql, "ref_order_id", orderInfo.ref_order_id);
sql = pService.GetIsNotNullUpdateSql(sql, "ref_order_no", orderInfo.ref_order_no);
sql = pService.GetIsNotNullUpdateSql(sql, "warehouse_id", orderInfo.warehouse_id);
sql = pService.GetIsNotNullUpdateSql(sql, "order_date", orderInfo.order_date);
sql = pService.GetIsNotNullUpdateSql(sql, "request_date", orderInfo.request_date);
sql = pService.GetIsNotNullUpdateSql(sql, "complete_date", orderInfo.complete_date);
sql = pService.GetIsNotNullUpdateSql(sql, "promise_date", orderInfo.promise_date);
sql = pService.GetIsNotNullUpdateSql(sql, "create_unit_id", orderInfo.create_unit_id);
sql = pService.GetIsNotNullUpdateSql(sql, "unit_id", orderInfo.unit_id);
sql = pService.GetIsNotNullUpdateSql(sql, "pos_id", orderInfo.pos_id);
sql = pService.GetIsNotNullUpdateSql(sql, "total_amount", orderInfo.total_amount.ToString());
sql = pService.GetIsNotNullUpdateSql(sql, "total_qty", orderInfo.total_qty.ToString());
sql = pService.GetIsNotNullUpdateSql(sql, "discount_rate", orderInfo.discount_rate.ToString());
sql = pService.GetIsNotNullUpdateSql(sql, "actual_amount", orderInfo.actual_amount.ToString());
sql = pService.GetIsNotNullUpdateSql(sql, "receive_points", orderInfo.receive_points.ToString());
sql = pService.GetIsNotNullUpdateSql(sql, "pay_points", orderInfo.pay_points.ToString());
sql = pService.GetIsNotNullUpdateSql(sql, "print_times", orderInfo.print_times.ToString());
sql = pService.GetIsNotNullUpdateSql(sql, "carrier_id", orderInfo.carrier_id);
sql = pService.GetIsNotNullUpdateSql(sql, "remark", orderInfo.remark);
sql = pService.GetIsNotNullUpdateSql(sql, "order_status", orderInfo.order_status);
sql = pService.GetIsNotNullUpdateSql(sql, "order_status_desc", orderInfo.order_status_desc);
sql = pService.GetIsNotNullUpdateSql(sql, "approve_time", orderInfo.approve_time);
sql = pService.GetIsNotNullUpdateSql(sql, "approve_user_id", orderInfo.approve_user_id);
sql = pService.GetIsNotNullUpdateSql(sql, "send_user_id", orderInfo.send_user_id);
sql = pService.GetIsNotNullUpdateSql(sql, "send_time", orderInfo.send_time);
sql = pService.GetIsNotNullUpdateSql(sql, "accpect_time", orderInfo.accpect_time);
sql = pService.GetIsNotNullUpdateSql(sql, "accpect_user_id", orderInfo.accpect_user_id);
sql = pService.GetIsNotNullUpdateSql(sql, "modify_time", orderInfo.create_time);
sql = pService.GetIsNotNullUpdateSql(sql, "modify_user_id", orderInfo.create_user_id);
sql = pService.GetIsNotNullUpdateSql(sql, "sales_unit_id", orderInfo.sales_unit_id);
sql = pService.GetIsNotNullUpdateSql(sql, "purchase_unit_id", orderInfo.purchase_unit_id);
sql = pService.GetIsNotNullUpdateSql(sql, "customer_id", this.loggingSessionInfo.CurrentLoggingManager.Customer_Id);
sql = sql + " where order_id = '" + orderInfo.order_id + "' ;";
#endregion
if (pTran != null)
{
this.SQLHelper.ExecuteNonQuery((SqlTransaction)pTran, CommandType.Text, sql.ToString(), null);
}
else
{
this.SQLHelper.ExecuteNonQuery(sql);
}
return(true);
}