private void ImportPData(List <SQLObj> listSql, string strId, string strReservId) { #region 维修项目信息 DataTable dpt = DBHelper.GetTable("维修项目数据", "tb_maintain_item", "*", string.Format(" maintain_id ='{0}'", strReservId), "", ""); for (int j = 0; j < dpt.Rows.Count; j++) { SQLObj obj = new SQLObj(); obj.cmdType = CommandType.Text; Dictionary <string, ParamObj> dicParam = new Dictionary <string, ParamObj>(); DataRow prow = dpt.Rows[j]; dicParam.Add("maintain_id", new ParamObj("maintain_id", strId, SysDbType.VarChar, 40)); dicParam.Add("item_no", new ParamObj("item_no", CommonCtrl.IsNullToString(prow["item_no"]), SysDbType.VarChar, 40)); dicParam.Add("item_type", new ParamObj("item_type", CommonCtrl.IsNullToString(prow["item_type"]), SysDbType.VarChar, 40)); dicParam.Add("item_name", new ParamObj("item_name", CommonCtrl.IsNullToString(prow["item_name"]), SysDbType.VarChar, 40)); dicParam.Add("man_hour_type", new ParamObj("man_hour_type", CommonCtrl.IsNullToString(prow["man_hour_type"]), SysDbType.VarChar, 40)); dicParam.Add("man_hour_quantity", new ParamObj("man_hour_quantity", !string.IsNullOrEmpty(CommonCtrl.IsNullToString(prow["man_hour_quantity"]))?CommonCtrl.IsNullToString(prow["man_hour_quantity"]):null, SysDbType.Decimal, 15)); dicParam.Add("man_hour_norm_unitprice", new ParamObj("man_hour_norm_unitprice", !string.IsNullOrEmpty(CommonCtrl.IsNullToString(prow["man_hour_norm_unitprice"]))?CommonCtrl.IsNullToString(prow["man_hour_norm_unitprice"]):null, SysDbType.Decimal, 15)); dicParam.Add("member_discount", new ParamObj("member_discount", !string.IsNullOrEmpty(CommonCtrl.IsNullToString(prow["member_discount"]))?CommonCtrl.IsNullToString(prow["member_discount"]):null, SysDbType.Decimal, 5)); dicParam.Add("member_price", new ParamObj("member_price", !string.IsNullOrEmpty(CommonCtrl.IsNullToString(prow["member_price"]))?CommonCtrl.IsNullToString(prow["member_price"]):null, SysDbType.Decimal, 15)); dicParam.Add("member_sum_money", new ParamObj("member_sum_money", !string.IsNullOrEmpty(CommonCtrl.IsNullToString(prow["member_sum_money"]))?CommonCtrl.IsNullToString(prow["member_sum_money"]):null, SysDbType.Decimal, 15)); dicParam.Add("sum_money_goods", new ParamObj("sum_money_goods", !string.IsNullOrEmpty(CommonCtrl.IsNullToString(prow["sum_money_goods"]))? CommonCtrl.IsNullToString(prow["sum_money_goods"]):null, SysDbType.Decimal, 15)); dicParam.Add("three_warranty", new ParamObj("three_warranty", CommonCtrl.IsNullToString(prow["three_warranty"]), SysDbType.VarChar, 2)); dicParam.Add("remarks", new ParamObj("remarks", CommonCtrl.IsNullToString(prow["remarks"]), SysDbType.VarChar, 200)); dicParam.Add("enable_flag", new ParamObj("enable_flag", "1", SysDbType.VarChar, 1)); dicParam.Add("item_id", new ParamObj("item_id", Guid.NewGuid().ToString(), SysDbType.VarChar, 40)); obj.sqlString = @"insert into [tb_maintain_item] (maintain_id,item_no,item_type,item_name,man_hour_type,man_hour_quantity,man_hour_norm_unitprice,member_discount ,member_price,member_sum_money,sum_money_goods,three_warranty,remarks,enable_flag,item_id) values (@maintain_id,@item_no,@item_type,@item_name,@man_hour_type,@man_hour_quantity,@man_hour_norm_unitprice,@member_discount ,@member_price,@member_sum_money,@sum_money_goods,@three_warranty,@remarks,@enable_flag,@item_id );"; obj.Param = dicParam; listSql.Add(obj); } #endregion }
/// <summary> /// 导入后更新旧件收货单导入状态 /// </summary> /// <param name="strReservId">旧件收货单Id</param> /// <param name="status">操作状体,0保存开放、1导入占用、2提交审核锁定</param> private void UpdateMaintainInfo(List <SQLObj> listSql, string strReservId, string status) { SQLObj obj = new SQLObj(); obj.cmdType = CommandType.Text; Dictionary <string, ParamObj> dicParam = new Dictionary <string, ParamObj>(); dicParam.Add("oldpart_id", new ParamObj("oldpart_id", strReservId, SysDbType.VarChar, 40)); if (status == "0") { //保存时,前置单据被释放 dicParam.Add("Import_status", new ParamObj("Import_status", "0", SysDbType.VarChar, 40));//开放 obj.sqlString = "update tb_maintain_oldpart_receiv_send set Import_status=@Import_status where oldpart_id=@oldpart_id"; } else if (status == "1") { //导入时,前置单据被占用 dicParam.Add("Import_status", new ParamObj("Import_status", "1", SysDbType.VarChar, 40));//占用 obj.sqlString = "update tb_maintain_oldpart_receiv_send set Import_status=@Import_status where oldpart_id=@oldpart_id"; } else if (status == "2") { //审核提交时,前置单据被锁定 dicParam.Add("Import_status", new ParamObj("Import_status", "2", SysDbType.VarChar, 40));//锁定 obj.sqlString = "update tb_maintain_oldpart_receiv_send set Import_status=@Import_status where oldpart_id=@oldpart_id"; } obj.Param = dicParam; listSql.Add(obj); }
private void UCMemberParaView_Load(object sender, EventArgs e) { CommonFuncCall.BindComBoxDataSource(cbomember_grade_id, "sys_member_grade", "请选择"); if (wStatus == WindowStatus.View) { string strSql = "select c.*,(select USER_NAME from sys_user where user_id =c.create_by )as create_Username , " + "(select USER_NAME from sys_user where user_id =c.update_by ) as update_username from tb_CustomerSer_member_setInfo c where c.setInfo_id='" + id + "'"; SQLObj sqlobj = new SQLObj(); sqlobj.cmdType = CommandType.Text; sqlobj.Param = new Dictionary <string, ParamObj>(); sqlobj.sqlString = strSql; DataSet ds = DBHelper.GetDataSet("查询会员参数设置信息", sqlobj); if (ds == null || ds.Tables[0].Rows.Count <= 0) { MessageBoxEx.Show("查询会员参数设置信息失败!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } DataTable dt = ds.Tables[0]; cbomember_grade_id.SelectedValue = dt.Rows[0]["member_grade_id"].ToString(); lblservice_project_discount.Text = dt.Rows[0]["service_project_discount"].ToString(); lblparts_discount.Text = dt.Rows[0]["parts_discount"].ToString(); lblSubscription_Ratio.Text = dt.Rows[0]["Subscription_Ratio"].ToString(); lblcreate_by.Text = dt.Rows[0]["create_Username"].ToString(); lblcreate_time.Text = Common.UtcLongToLocalDateTime(Convert.ToInt64(dt.Rows[0]["create_time"].ToString())).ToString(); lblupdate_by.Text = dt.Rows[0]["update_username"].ToString(); lblupdate_time.Text = Common.UtcLongToLocalDateTime(Convert.ToInt64(dt.Rows[0]["update_time"].ToString())).ToString(); ThreadPool.QueueUserWorkItem(new WaitCallback(this._LoadData)); } DataGridViewStyle.DataGridViewBgColor(dgvprojrct); DataGridViewStyle.DataGridViewBgColor(dgvparts); }
void UCRepairRescueView_VerifyEvent(object sender, EventArgs e) { //if (MessageBoxEx.Show("确认要审核吗?", "提示", MessageBoxButtons.OKCancel) != DialogResult.OK) //{ // return; //} verify = new UCVerify(); if (verify.ShowDialog() == DialogResult.OK) { List <SQLObj> listSql = new List <SQLObj>(); SQLObj obj = new SQLObj(); obj.cmdType = CommandType.Text; Dictionary <string, ParamObj> dicParam = new Dictionary <string, ParamObj>(); dicParam.Add("rescue_id", new ParamObj("rescue_id", strRescueId, SysDbType.VarChar, 40)); //单据ID dicParam.Add("document_status", new ParamObj("document_status", verify.auditStatus, SysDbType.VarChar, 40)); //单据状态 dicParam.Add("Verify_advice", new ParamObj("Verify_advice", verify.Content, SysDbType.VarChar, 200)); //审核意见 dicParam.Add("update_by", new ParamObj("update_by", HXCPcClient.GlobalStaticObj.UserID, SysDbType.VarChar, 40)); //修改人Id dicParam.Add("update_name", new ParamObj("update_name", HXCPcClient.GlobalStaticObj.UserName, SysDbType.VarChar, 40)); //修改人姓名 dicParam.Add("update_time", new ParamObj("update_time", Common.LocalDateTimeToUtcLong(HXCPcClient.GlobalStaticObj.CurrentDateTime).ToString(), SysDbType.BigInt)); //修改时间 obj.sqlString = "update tb_maintain_rescue_info set document_status=@document_status,Verify_advice=@Verify_advice,update_by=@update_by,update_name=@update_name,update_time=@update_time where rescue_id=@rescue_id"; obj.Param = dicParam; listSql.Add(obj); if (DBHelper.BatchExeSQLMultiByTrans("更新单据状态为审核", listSql)) { MessageBoxEx.Show("审核成功!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); uc.BindPageData(); deleteMenuByTag(this.Tag.ToString(), uc.Name); } } }
/// <summary> /// 根据父级编码,获取所有子级字典 /// </summary> /// <param name="code"></param> /// <param name="isAll">是否有全部</param> /// <returns></returns> public static DataTable GetDictionarrByCode(string code, bool isAll) { SQLObj sqlObj = new SQLObj(); sqlObj.cmdType = CommandType.Text; sqlObj.sqlString = @"select b.dic_id,b.dic_name from sys_dictionaries a inner join sys_dictionaries b on a.dic_id=b.parent_id where a.dic_code=@dic_code"; sqlObj.Param = new Dictionary <string, ParamObj>(); sqlObj.Param.Add("dic_code", new ParamObj("dic_code", code, SysDbType.VarChar, 40)); DataSet ds = DBHelper.GetDataSet("", GlobalStaticObj_Server.DbPrefix + GlobalStaticObj_Server.CommAccCode, sqlObj); if (ds == null || ds.Tables.Count == 0 || ds.Tables[0].Rows.Count == 0) { return(null); } DataTable dt = ds.Tables[0]; if (isAll) { DataRow dr = dt.NewRow(); dr["dic_id"] = string.Empty; dr["dic_name"] = "全部"; dt.Rows.InsertAt(dr, 0); } return(dt); }
private void SaveMaterialsData(List <SQLObj> listSql) { try { foreach (DataGridViewRow dgvr in dgvMaterials.Rows) { string strPNO = CommonCtrl.IsNullToString(dgvr.Cells["service_no"].Value); string strPCode = CommonCtrl.IsNullToString(dgvr.Cells["parts_code"].Value); if (strPNO.Length > 0 && strPCode.Length > 0) { SQLObj obj = new SQLObj(); obj.cmdType = CommandType.Text; Dictionary <string, ParamObj> dicParam = new Dictionary <string, ParamObj>(); dicParam.Add("process_mode", new ParamObj("process_mode", dgvr.Cells["process_mode"].Value, SysDbType.VarChar, 40)); //处理方式 dicParam.Add("send_num", new ParamObj("send_num", dgvr.Cells["send_num"].Value, SysDbType.Decimal)); //发送数量 dicParam.Add("parts_id", new ParamObj("parts_id", dgvr.Cells["parts_id"].Value, SysDbType.VarChar, 40)); opName = "更新旧件收货单"; obj.sqlString = @"update tb_maintain_oldpart_recycle_material_detail set process_mode=@process_mode,send_num=@send_num where parts_id=@parts_id"; obj.Param = dicParam; listSql.Add(obj); } } } catch (Exception ex) { HXCPcClient.GlobalStaticObj.GlobalLogService.WriteLog(ex); } }
/// <summary> /// 验证应收应付单据本次结算是否大于结算金额 /// </summary> /// <param name="orderType">单据类型</param> /// <param name="id">单据ID</param> /// <returns></returns> public static bool CheckDocumentMoney(DataSources.EnumOrderType orderType, string id) { SQLObj sqlSettlement = new SQLObj(); sqlSettlement.cmdType = CommandType.Text; sqlSettlement.Param = new Dictionary <string, ParamObj>(); sqlSettlement.Param.Add("order_id", new ParamObj("order_id", id, SysDbType.VarChar, 40)); if (orderType == DataSources.EnumOrderType.RECEIVABLE) { sqlSettlement.sqlString = @"select a.order_id,a.settlement_money from tb_balance_documents a left join v_YingShou c on a.documents_id=c.documents_id where (a.billing_money- isnull(c.money,0))<a.settlement_money and a.order_id=@order_id"; } else { sqlSettlement.sqlString = @"select a.order_id,a.settlement_money from tb_balance_documents a left join v_YingFu c on a.documents_id=c.documents_id where (a.billing_money- isnull(c.money,0))<a.settlement_money and a.order_id=@order_id"; } DataSet ds = DBHelper.GetDataSet("验证应收应付单据", sqlSettlement); if (ds == null || ds.Tables.Count == 0 || ds.Tables[0].Rows.Count == 0) { return(false); } else { return(true); } }
/// <summary> /// 获取数据列信息 /// </summary> /// <param name="dbName">数据库名称</param> /// <param name="tableName">数据表名称</param> /// <param name="columnName">数据列名称</param> /// <returns></returns> public static DataRow GetColumnInfo(String dbName, String tableName, String columnName) { if (String.IsNullOrEmpty(dbName) || String.IsNullOrEmpty(tableName) || String.IsNullOrEmpty(columnName)) { return(null); } var sql = String.Format( " SELECT column_name= convert(varchar(100), a.name), table_name= convert(varchar(50), d.name ), type= CONVERT(varchar(50),b.name), library_name= '{0}', description=convert(varchar(50), isnull(g.[value],'')) FROM dbo.syscolumns a left join dbo.systypes b on a.xusertype=b.xusertype inner join dbo.sysobjects d on a.id=d.id and d.xtype='U' and d.name<>'dtproperties' left join dbo.syscomments e on a.cdefault=e.id left join sys.extended_properties g on a.id=g.major_id and a.colid=g.minor_id left join sys.extended_properties f on d.id=f.major_id and f.minor_id=0 where d.name ='{1}' and a.name = '{2}'", dbName, tableName, columnName); var sqlObj = new SQLObj { Param = new Dictionary <string, ParamObj>(), cmdType = CommandType.Text, sqlString = sql }; try { var ds = DBHelper.GetDataSet("获取数据库列信息", dbName, sqlObj); if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0) { return(ds.Tables[0].Rows[0]); } } catch (Exception ex) { LogAssistant.LogService.WriteLog(ex); return(null); } return(null); }
/// <summary> /// /// </summary> /// <param name="listSql">SQLObj listSql</param> /// <param name="strId">公告Id</param> private void SavePerson(List <SQLObj> listSql, string strId) { if (this.winStatus == WindowStatus.Edit) { List <SQLObj> listSqlU = new List <SQLObj>(); SQLObj objU = new SQLObj(); objU.cmdType = CommandType.Text; Dictionary <string, ParamObj> dicParam = new Dictionary <string, ParamObj>(); dicParam.Add("announcement_id", new ParamObj("announcement_id", strId, SysDbType.VarChar, 40));//Id objU.sqlString = @"delete from sys_announcement_user where announcement_id=@announcement_id ;"; objU.Param = dicParam; listSqlU.Add(objU); DBHelper.BatchExeSQLMultiByTrans("", listSqlU); } string strPerName = rtbPerson.Text.Trim(); string strPerId = rtbPerson.Tag.ToString(); string[] PerIdArrary = strPerId.Split(','); string[] PerNameArrary = strPerName.Split(','); for (int i = 0; i < PerIdArrary.Length; i++) { SQLObj obj = new SQLObj(); obj.cmdType = CommandType.Text; Dictionary <string, ParamObj> dicParam = new Dictionary <string, ParamObj>(); dicParam.Add("announcement_id", new ParamObj("announcement_id", strId, SysDbType.VarChar, 40)); //公告Id dicParam.Add("user_id", new ParamObj("user_id", PerIdArrary[i], SysDbType.VarChar, 40)); //用户ID dicParam.Add("user_name", new ParamObj("user_name", PerNameArrary[i], SysDbType.VarChar, 40)); //用户名 dicParam.Add("announcement_user_id", new ParamObj("announcement_user_id", Guid.NewGuid().ToString(), SysDbType.VarChar, 40)); //Id obj.sqlString = @"insert into sys_announcement_user (announcement_id,user_id,user_name,announcement_user_id) values (@announcement_id,@user_id,@user_name,@announcement_user_id);"; obj.Param = dicParam; listSql.Add(obj); } }
/// <summary> /// 判断数据表是否存在 /// </summary> /// <param name="dbName">数据库名称</param> /// <param name="tableName">数据表名称</param> /// <returns></returns> public static bool TableIsExists(String dbName, String tableName) { if (String.IsNullOrEmpty(dbName) || String.IsNullOrEmpty(tableName)) { return(false); } var sql = String.Format("SELECT * FROM INFORMATION_SCHEMA.TABLES where TABLE_NAME = '{0}'", tableName); var sqlObj = new SQLObj { Param = new Dictionary <string, ParamObj>(), cmdType = CommandType.Text, sqlString = sql }; try { var ds = DBHelper.GetDataSet(String.Format("判断数据库({0})是否存在", tableName), dbName, sqlObj); if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0) { return(true); } } catch (Exception ex) { LogAssistant.LogService.WriteLog(ex); return(false); } return(false); }
/// <summary> /// 判断数据库是否存在 /// </summary> /// <param name="dbName">数据库名称</param> /// <returns></returns> public static bool DbIsExists(String dbName) { if (String.IsNullOrEmpty(dbName)) { return(false); } var sql = String.Format("SELECT DBID,NAME FROM MASTER.DBO.SYSDATABASES WHERE NAME='{0}'", dbName); var sqlObj = new SQLObj { Param = new Dictionary <string, ParamObj>(), cmdType = CommandType.Text, sqlString = sql }; try { var ds = DBHelper.GetDataSet(String.Format("判断数据库({0})是否存在", dbName), "MASTER", sqlObj); if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0) { return(true); } } catch (Exception ex) { LogAssistant.LogService.WriteLog(ex); return(false); } return(false); }
/// <summary> 异步数据查询 /// </summary> /// <param name="obj"></param> private void _BindPageData(object obj) { SQLObj sql = new SQLObj(); sql.Param = new Dictionary <string, SYSModel.ParamObj>(); sql.cmdType = CommandType.Text; sql.sqlString = " select top 500 a.parts_id,a.ser_parts_code,a.parts_name,a.default_unit,"; sql.sqlString += " b.id,b.wh_id,b.max_num,b.min_num,b.is_default,b.create_time "; sql.sqlString += " from tb_parts a left join tr_hourse_parts b on a.parts_id=b.parts_id "; if (obj.ToString().Length > 0) { sql.sqlString += " where "; sql.sqlString += obj.ToString(); } sql.sqlString += " order by a.create_time desc"; DataTable _dt = null; try { DataSet ds = DBHelper.GetDataSet("获取仓库配件关系", sql); if (ds != null && ds.Tables.Count > 0) { _dt = ds.Tables[0]; } } catch { } this.Invoke(this.uiHandler, _dt); }
private void ImportAData(List <SQLObj> listSql, string strId, string strReservId) { #region 附件信息 StringBuilder sbWhere = new StringBuilder(); sbWhere.AppendFormat("relation_object='{0}'", "tb_maintain_reservation"); sbWhere.AppendFormat(" and relation_object_id='{0}'", strReservId); sbWhere.AppendFormat(" and enable_flag='{0}'", (int)DataSources.EnumEnableFlag.USING); sbWhere.Append(" and is_main='0'"); DataTable dat = DBHelper.GetTable("绑定附件", "attachment_info", "*", sbWhere.ToString(), "", ""); for (int m = 0; m < dat.Rows.Count; m++) { SQLObj obj = new SQLObj(); obj.cmdType = CommandType.Text; Dictionary <string, ParamObj> dicParam = new Dictionary <string, ParamObj>(); DataRow drow = dat.Rows[m]; dicParam.Add("att_name", new ParamObj("att_name", CommonCtrl.IsNullToString(drow["att_name"]), SysDbType.NVarChar, 15)); dicParam.Add("att_type", new ParamObj("att_type", CommonCtrl.IsNullToString(drow["att_type"]), SysDbType.NVarChar, 15)); dicParam.Add("att_path", new ParamObj("att_path", CommonCtrl.IsNullToString(drow["att_path"]), SysDbType.VarChar, 40)); dicParam.Add("remark", new ParamObj("remark", CommonCtrl.IsNullToString(drow["remark"]), SysDbType.NVarChar, 300)); dicParam.Add("att_id", new ParamObj("att_id", Guid.NewGuid().ToString(), SysDbType.VarChar, 40)); dicParam.Add("is_main", new ParamObj("is_main", (int)DataSources.EnumYesNo.NO, SysDbType.VarChar, 5)); dicParam.Add("relation_object", new ParamObj("relation_object", "tb_maintain_info", SysDbType.NVarChar, 30)); dicParam.Add("relation_object_id", new ParamObj("relation_object_id", strId, SysDbType.VarChar, 40)); dicParam.Add("enable_flag", new ParamObj("enable_flag", (int)DataSources.EnumEnableFlag.USING, SysDbType.VarChar, 5)); dicParam.Add("create_by", new ParamObj("create_by", GlobalStaticObj.UserID, SysDbType.NVarChar, 40)); dicParam.Add("create_time", new ParamObj("create_time", DateTime.UtcNow.Ticks, SysDbType.BigInt)); obj.sqlString = @"insert into [attachment_info] (att_name,att_type,att_path,remark,att_id,is_main,relation_object,relation_object_id,enable_flag,create_by,create_time) values (@att_name,@att_type,@att_path,@remark,@att_id,@is_main,@relation_object,@relation_object_id,@enable_flag,@create_by,@create_time);"; obj.Param = dicParam; listSql.Add(obj); } #endregion }
/// <summary> 异步数据查询 /// </summary> /// <param name="obj"></param> private void _BindData(object obj) { string id = obj.ToString(); StringBuilder sb = new StringBuilder(); sb.Append(string.Format("select * from sys_announcement_org where announcement_id='{0}'", id)); sb.Append(";"); sb.Append(string.Format("select * from sys_announcement_user where announcement_id='{0}'", id)); SQLObj sql = new SQLObj(); sql.Param = new Dictionary <string, SYSModel.ParamObj>(); sql.cmdType = CommandType.Text; sql.sqlString = sb.ToString(); DataSet ds = null; try { ds = DBHelper.GetDataSet("获取公告接收组织和用户信息", sql); } catch { ds = null; } this.Invoke(this.uiHandler, ds); }
/// <summary> /// 绑定库存 /// </summary> /// <param name="parts_id">配件ID</param> /// <param name="wh_id">仓库ID</param> void BindStock(string parts_id, string wh_id) { StringBuilder sbWhere = new StringBuilder(); sbWhere.AppendFormat("stock_part_id='{0}'", parts_id); if (wh_id.Length > 0) { sbWhere.AppendFormat(" and wh_id='{0}'", wh_id); } // select parts_name,wh_name, //sum(case when statistic_Type=0 then statistic_count else 0 end) paper_count, //sum(case when statistic_Type=1 then statistic_count else 0 end) actual_count //from tb_parts_stock_p where stock_part_id='99baa9dd-feab-45fe-a1be-1f2d295a6ba4' //group by parts_name,wh_name // string fileds = string.Format(@"parts_name,wh_name,case when statistic_Type={0} then statistic_count else 0 end paper_count, //case when statistic_Type={1} then statistic_count else 0 end actual_count", (int)DataSources.EnumStatisticType.PaperCount, (int)DataSources.EnumStatisticType.ActualCount); string stockSql = string.Format(@"select parts_name,wh_name, sum(case when statistic_Type=0 then statistic_count else 0 end) paper_count, sum(case when statistic_Type=1 then statistic_count else 0 end) actual_count from tb_parts_stock_p where stock_part_id='{0}' group by parts_name,wh_name", parts_id); SQLObj partsStock = new SQLObj(); partsStock.cmdType = CommandType.Text; partsStock.Param = new Dictionary <string, ParamObj>(); partsStock.sqlString = stockSql; DataTable dt = DBHelper.GetDataSet("查询配件库存", partsStock).Tables[0]; dgvDetail.DataSource = dt; }
/// <summary> /// /// </summary> /// <param name="listSql">SQLObj listSql</param> /// <param name="strId">公告Id</param> private void SaveOrg(List <SQLObj> listSql, string strId) { if (this.winStatus == WindowStatus.Edit) { List <SQLObj> listSqlO = new List <SQLObj>(); SQLObj objO = new SQLObj(); objO.cmdType = CommandType.Text; Dictionary <string, ParamObj> dicParamO = new Dictionary <string, ParamObj>(); dicParamO.Add("announcement_id", new ParamObj("announcement_id", strId, SysDbType.VarChar, 40));//Id objO.sqlString = @"delete from sys_announcement_org where announcement_id=@announcement_id ;"; objO.Param = dicParamO; listSqlO.Add(objO); DBHelper.BatchExeSQLMultiByTrans("", listSqlO); } string strOrgName = rtbOrganization.Text.Trim(); string strOrgId = rtbOrganization.Tag.ToString(); string[] OrgIdArrary = strOrgId.Split(','); string[] OrgNameArrary = strOrgName.Split(','); for (int i = 0; i < OrgIdArrary.Length; i++) { SQLObj obj = new SQLObj(); obj.cmdType = CommandType.Text; Dictionary <string, ParamObj> dicParam = new Dictionary <string, ParamObj>(); dicParam.Add("announcement_id", new ParamObj("announcement_id", strId, SysDbType.VarChar, 40)); //公告Id dicParam.Add("org_id", new ParamObj("org_id", OrgIdArrary[i], SysDbType.VarChar, 40)); //组织结构ID dicParam.Add("org_name", new ParamObj("org_name", OrgNameArrary[i], SysDbType.VarChar, 40)); //组织结构名 dicParam.Add("announcement_org_id", new ParamObj("announcement_org_id", Guid.NewGuid().ToString(), SysDbType.VarChar, 40)); //Id obj.sqlString = @"insert into sys_announcement_org (announcement_id,org_id,org_name,announcement_org_id) values (@announcement_id,@org_id,@org_name,@announcement_org_id);"; obj.Param = dicParam; listSql.Add(obj); } }
/// <summary> /// 添加sql语句-图片 /// </summary> /// <param name="listSql">listSql</param> /// <param name="partID">用户id</param> /// <param name="path">图片id</param> /// <returns></returns> private List <SQLObj> AddPhoto(List <SQLObj> listSql, string partID, string path) { if (path != string.Empty) { SQLObj sqlObj = new SQLObj(); sqlObj.cmdType = CommandType.Text; Dictionary <string, ParamObj> dic = new Dictionary <string, ParamObj>(); dic.Add("att_path", new ParamObj("att_path", path, SysDbType.VarChar, 40)); sqlObj.Param = dic; if (photoID.Length == 0) { dic.Add("att_name", new ParamObj("att_name", "用户图片", SysDbType.NVarChar, 15)); dic.Add("att_type", new ParamObj("att_type", "图片", SysDbType.NVarChar, 15)); photoID = Guid.NewGuid().ToString(); dic.Add("is_main", new ParamObj("is_main", (int)DataSources.EnumYesNo.Yes, SysDbType.VarChar, 5)); dic.Add("relation_object", new ParamObj("relation_object", "tb_parts", SysDbType.NVarChar, 30)); dic.Add("relation_object_id", new ParamObj("relation_object_id", partID, SysDbType.VarChar, 40)); dic.Add("enable_flag", new ParamObj("enable_flag", (int)DataSources.EnumEnableFlag.USING, SysDbType.VarChar, 5)); dic.Add("create_by", new ParamObj("create_by", GlobalStaticObj.UserID, SysDbType.NVarChar, 40)); dic.Add("create_time", new ParamObj("create_time", DateTime.UtcNow.Ticks, SysDbType.BigInt)); sqlObj.sqlString = @"insert into [attachment_info] ([att_id],[att_name],[att_type],[att_path],[relation_object],[relation_object_id],[enable_flag],[create_by],[create_time],[is_main]) values (@att_id,@att_name,@att_type,@att_path,@relation_object,@relation_object_id,@enable_flag,@create_by,@create_time,@is_main);"; } else { dic.Add("update_by", new ParamObj("update_by", GlobalStaticObj.UserID, SysDbType.NVarChar, 40)); dic.Add("update_time", new ParamObj("update_time", DateTime.UtcNow.Ticks, SysDbType.BigInt)); sqlObj.sqlString = "update [attachment_info] set [att_path]=@att_path,[update_by]=@update_by,[update_time]=@update_time where [att_id]=@att_id;"; } dic.Add("att_id", new ParamObj("att_id", photoID, SysDbType.VarChar, 40)); listSql.Add(sqlObj); } return(listSql); }
void UCBulletinAddOrEdit_VerifyEvent(object sender, EventArgs e) { if (MessageBoxEx.Show("确认要审核吗?", "提示", MessageBoxButtons.OKCancel) != DialogResult.OK) { return; } verify = new UCVerify(); if (verify.ShowDialog() == DialogResult.OK) { List <SQLObj> listSql = new List <SQLObj>(); SQLObj obj = new SQLObj(); obj.cmdType = CommandType.Text; Dictionary <string, ParamObj> dicParam = new Dictionary <string, ParamObj>(); dicParam.Add("announcement_id", new ParamObj("announcement_id", id, SysDbType.VarChar, 40)); //单据ID dicParam.Add("status", new ParamObj("status", verify.auditStatus, SysDbType.VarChar, 40)); //单据状态 dicParam.Add("Verify_advice", new ParamObj("Verify_advice", verify.Content, SysDbType.VarChar, 200)); //审核意见 obj.sqlString = "update sys_announcement set status=@status,Verify_advice=@Verify_advice where announcement_id=@announcement_id"; obj.Param = dicParam; listSql.Add(obj); if (DBHelper.BatchExeSQLMultiByTrans("更新单据状态为提交", listSql)) { if (this.RefreshDataStart != null) { this.RefreshDataStart(); } MessageBoxEx.Show("审核成功!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); deleteMenuByTag(this.Tag.ToString(), "UCBulletinAddOrEdit"); } } }
/// <summary> /// 质检-更新项目维修进度 /// </summary> /// <param name="listSql">SQLObj list</param> /// <param name="strRId">单据Id字符串</param> /// <param name="PStatus">项目调度维修进度枚举</param> private void SaveProjectData(List <SQLObj> listSql, string strRId, DataSources.EnumProjectDisStatus PStatus) { strRId = strRId.Substring(0, strRId.Length - 1); string[] pArray = strRId.Split(','); string strNRId = string.Empty; for (int i = 0; i < pArray.Length; i++) { strNRId += "'" + pArray[i] + "'" + ","; } strNRId = strNRId.Substring(0, strNRId.Length - 1); DataTable dpt = DBHelper.GetTable("维修项目数据", "tb_maintain_item", "*", string.Format(" maintain_id in ({0})", strNRId), "", "order by maintain_id desc");; if (dpt.Rows.Count > 0) { for (int i = 0; i < dpt.Rows.Count; i++) { SQLObj obj = new SQLObj(); obj.cmdType = CommandType.Text; Dictionary <string, ParamObj> dicParam = new Dictionary <string, ParamObj>(); DataRow dpr = dpt.Rows[i]; dicParam.Add("item_id", new ParamObj("item_id", dpr["item_id"], SysDbType.VarChar, 40)); dicParam.Add("repair_progress", new ParamObj("repair_progress", Convert.ToInt32(PStatus), SysDbType.VarChar, 40)); //维修进度 obj.sqlString = @"update tb_maintain_item set repair_progress=@repair_progress where item_id=@item_id"; obj.Param = dicParam; listSql.Add(obj); } } }
void UCOldPartsPalautusManager_VerifyEvent(object sender, EventArgs e) { List <string> listField = new List <string>(); foreach (DataGridViewRow dr in dgvRData.Rows) { object isCheck = dr.Cells["colCheck"].EditedFormattedValue; if (isCheck != null && (bool)isCheck) { listField.Add(dr.Cells["return_id"].Value.ToString()); } } if (listField.Count <= 0) { MessageBoxEx.Show("请选择需要审核的记录!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); return; } if (MessageBoxEx.Show("确认要审核吗?", "提示", MessageBoxButtons.OKCancel) != DialogResult.OK) { return; } verify = new UCVerify(); if (verify.ShowDialog() == DialogResult.OK) { List <SQLObj> listSql = new List <SQLObj>(); foreach (DataGridViewRow dr in dgvRData.Rows) { object isCheck = dr.Cells["colCheck"].EditedFormattedValue; if (isCheck != null && (bool)isCheck) { SQLObj obj = new SQLObj(); obj.cmdType = CommandType.Text; Dictionary <string, ParamObj> dicParam = new Dictionary <string, ParamObj>(); dicParam.Add("return_id", new ParamObj("return_id", dr.Cells["return_id"].Value, SysDbType.VarChar, 40)); //单据ID dicParam.Add("info_status", new ParamObj("info_status", verify.auditStatus, SysDbType.VarChar, 40)); //单据状态 dicParam.Add("verify_advice", new ParamObj("verify_advice", verify.Content, SysDbType.VarChar, 200)); //审核意见 dicParam.Add("update_by", new ParamObj("update_by", HXCPcClient.GlobalStaticObj.UserID, SysDbType.VarChar, 40)); //修改人Id dicParam.Add("update_name", new ParamObj("update_name", HXCPcClient.GlobalStaticObj.UserName, SysDbType.VarChar, 40)); //修改人姓名 dicParam.Add("update_time", new ParamObj("update_time", Common.LocalDateTimeToUtcLong(HXCPcClient.GlobalStaticObj.CurrentDateTime).ToString(), SysDbType.BigInt)); //修改时间 obj.sqlString = "update tb_maintain_oldpart_recycle set info_status=@info_status,verify_advice=@verify_advice,update_by=@update_by,update_name=@update_name,update_time=@update_time where return_id=@return_id"; obj.Param = dicParam; listSql.Add(obj); } } if (DBHelper.BatchExeSQLMultiByTrans("更新单据状态为审核", listSql)) { string strMsg = string.Empty; if (verify.auditStatus == DataSources.EnumAuditStatus.AUDIT) { strMsg = "成功"; } else { strMsg = "不通过"; } MessageBoxEx.Show("审核" + strMsg + "!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); BindPageData(); } } }
void UCRepairCallbackView_SubmitEvent(object sender, EventArgs e) { if (MessageBoxEx.Show("确认要提交吗?", "提示", MessageBoxButtons.OKCancel) != DialogResult.OK) { return; } List <SQLObj> listSql = new List <SQLObj>(); SQLObj obj = new SQLObj(); obj.cmdType = CommandType.Text; Dictionary <string, ParamObj> dicParam = new Dictionary <string, ParamObj>(); if (strStatus == Convert.ToInt32(DataSources.EnumAuditStatus.DRAFT).ToString()) { labMaintain_noS.Text = CommonUtility.GetNewNo(SYSModel.DataSources.EnumProjectType.RepairCallback); } dicParam.Add("repair_no", new ParamObj("repair_no", labMaintain_noS.Text, SysDbType.VarChar, 40)); //单据编号 dicParam.Add("repair_id", new ParamObj("repair_id", strCallbackId, SysDbType.VarChar, 40)); //单据ID dicParam.Add("document_status", new ParamObj("document_status", DataSources.EnumAuditStatus.SUBMIT, SysDbType.VarChar, 40)); //单据状态 dicParam.Add("update_by", new ParamObj("update_by", HXCPcClient.GlobalStaticObj.UserID, SysDbType.VarChar, 40)); //修改人Id dicParam.Add("update_name", new ParamObj("update_name", HXCPcClient.GlobalStaticObj.UserName, SysDbType.VarChar, 40)); //修改人姓名 dicParam.Add("update_time", new ParamObj("update_time", Common.LocalDateTimeToUtcLong(HXCPcClient.GlobalStaticObj.CurrentDateTime).ToString(), SysDbType.BigInt)); //修改时间 obj.sqlString = "update tb_maintain_back_repair set document_status=@document_status,repair_no=@repair_no,update_by=@update_by,update_name=@update_name,update_time=@update_time where repair_id=@repair_id"; obj.Param = dicParam; listSql.Add(obj); if (DBHelper.BatchExeSQLMultiByTrans("更新单据状态为提交", listSql)) { MessageBoxEx.Show("提交成功!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); uc.BindPageData(); deleteMenuByTag(this.Tag.ToString(), uc.Name); } }
public static DataSet UserLogin(LoginInput loginO, string currAccDbName, string IPStr) { Dictionary <string, ParamObj> dic = new Dictionary <string, ParamObj>(); ParamObj paraO1 = new ParamObj(); paraO1.name = "land_name"; paraO1.size = 40; paraO1.type = SysDbType.VarChar; paraO1.value = loginO.username; ParamObj paraO2 = new ParamObj(); paraO2.name = "password"; paraO2.size = 40; paraO2.type = SysDbType.VarChar; paraO2.value = loginO.pwd; ParamObj paraO3 = new ParamObj(); paraO3.name = "login_time"; paraO3.type = SysDbType.BigInt; paraO3.value = System.DateTime.Now.ToUniversalTime().Ticks; ParamObj paraO4 = new ParamObj(); paraO4.name = "computer_ip"; paraO4.size = 40; paraO4.type = SysDbType.VarChar; paraO4.value = IPStr; ParamObj paraO5 = new ParamObj(); paraO5.name = "computer_name"; paraO5.size = 40; paraO5.type = SysDbType.NVarChar; paraO5.value = loginO.ComputerName; ParamObj paraO6 = new ParamObj(); paraO6.name = "computer_mac"; paraO6.size = 40; paraO6.type = SysDbType.VarChar; paraO6.value = loginO.MAC; ParamObj paraO7 = new ParamObj(); paraO7.name = "login_Id"; paraO7.size = 40; paraO7.type = SysDbType.VarChar; paraO7.value = loginO.Login_Id; dic.Add("land_name", paraO1); dic.Add("password", paraO2); dic.Add("login_time", paraO3); dic.Add("computer_ip", paraO4); dic.Add("computer_name", paraO5); dic.Add("computer_mac", paraO6); dic.Add("login_Id", paraO7); SQLObj sqlObj = new SQLObj(); sqlObj.cmdType = System.Data.CommandType.StoredProcedure; sqlObj.sqlString = "ServerUserLogin"; sqlObj.Param = dic; DataSet ds = DBHelper.GetDataSet("服务器端用户登录", currAccDbName, sqlObj); return(ds); }
/// <summary> /// 提交、审核时如果为前置单据则更新前置单据的状态 /// </summary> /// <param name="strReservId">预约单Id</param> /// <param name="status">操作状态,0提交、审核,1删除</param> private void UpdateMaintainInfo(List <SQLObj> listSql, string strReservId, string strSource, string status) { if (!string.IsNullOrEmpty(strReservId) && !string.IsNullOrEmpty(strSource)) { SQLObj obj = new SQLObj(); obj.cmdType = CommandType.Text; Dictionary <string, ParamObj> dicParam = new Dictionary <string, ParamObj>(); if (strSource == "1") //预约单 { dicParam.Add("update_by", new ParamObj("update_by", HXCPcClient.GlobalStaticObj.UserID, SysDbType.VarChar, 40)); //修改人Id dicParam.Add("update_name", new ParamObj("update_name", HXCPcClient.GlobalStaticObj.UserName, SysDbType.VarChar, 40)); //修改人姓名 dicParam.Add("update_time", new ParamObj("update_time", Common.LocalDateTimeToUtcLong(HXCPcClient.GlobalStaticObj.CurrentDateTime).ToString(), SysDbType.BigInt)); //修改时间 if (status == "0") { //审核提交时,前置单据被锁定并添加维修单号 dicParam.Add("reserv_id", new ParamObj("reserv_id", strReservId, SysDbType.VarChar, 40)); dicParam.Add("Import_status", new ParamObj("Import_status", "2", SysDbType.VarChar, 40));//锁定 obj.sqlString = "update tb_maintain_reservation set Import_status=@Import_status,update_by=@update_by,update_name=@update_name,update_time=@update_time where reserv_id=@reserv_id"; } else if (status == "1") { //删除时,前置单据中的维修编号置空、前置状体置为开放0 dicParam.Add("reserv_id", new ParamObj("reserv_id", strReservId, SysDbType.VarChar, 40)); dicParam.Add("maintain_no", new ParamObj("maintain_no", null, SysDbType.VarChar, 40)); dicParam.Add("Import_status", new ParamObj("Import_status", "0", SysDbType.VarChar, 40));//开放 obj.sqlString = "update tb_maintain_reservation set maintain_no=@maintain_no,Import_status=@Import_status,update_by=@update_by,update_name=@update_name,update_time=@update_time where reserv_id=@reserv_id"; } } obj.Param = dicParam; listSql.Add(obj); } }
private static void _LoadPreData(object obj) { StringBuilder sb = new StringBuilder(); sb.Append("select * from sys_dictionaries"); sb.Append(";"); sb.Append("select * from tb_organization"); sb.Append(";"); sb.Append("select * from sys_user"); sb.Append(";"); sb.Append("select * from sys_area"); SQLObj sql = new SQLObj(); sql.Param = new Dictionary <string, SYSModel.ParamObj>(); sql.cmdType = CommandType.Text; sql.sqlString = sb.ToString(); try { DataSet ds = DBHelper.GetDataSet("获取预加载信息", sql); if (ds != null && ds.Tables.Count > 0) { DtDict = ds.Tables[0]; DtDept = ds.Tables[1]; DtUser = ds.Tables[2]; DtArea = ds.Tables[3]; } } catch { } }
private void StatusSql(ICollection <SQLObj> listSql, ICollection idList, string status) { if (idList.Count <= 0) { return; } foreach (string id in idList) { var sqlObj = new SQLObj { cmdType = CommandType.Text }; var dicParam = new Dictionary <string, ParamObj> { { "v_id", new ParamObj("v_id", id, SysDbType.VarChar, 40) }, { "status", new ParamObj("status", status, SysDbType.VarChar, 40) }, { "update_by", new ParamObj("update_by", GlobalStaticObj.UserID, SysDbType.NVarChar, 40) }, { "update_time", new ParamObj("update_time", Common.LocalDateTimeToUtcLong(GlobalStaticObj.CurrentDateTime), SysDbType.BigInt) } };//参数 sqlObj.sqlString = @"update tb_vehicle set status=@status,update_by=@update_by,update_time=@update_time where v_id=@v_id;"; sqlObj.Param = dicParam; listSql.Add(sqlObj); } }
private void StatusSql(ICollection <SQLObj> listSql, ICollection idList, string status) { try { if (idList.Count <= 0) { return; } foreach (string id in idList) { var sqlObj = new SQLObj { cmdType = CommandType.Text }; var dicParam = new Dictionary <string, ParamObj> { { "cust_id", new ParamObj("cust_id", id, SysDbType.VarChar, 40) }, { "status", new ParamObj("status", status, SysDbType.VarChar, 40) }, { "update_by", new ParamObj("update_by", GlobalStaticObj.UserID, SysDbType.NVarChar, 40) }, { "update_time", new ParamObj("update_time", Common.LocalDateTimeToUtcLong(GlobalStaticObj.CurrentDateTime), SysDbType.BigInt) } };//参数 sqlObj.sqlString = @"update [tb_customer] set status=@status,update_by=@update_by,update_time=@update_time where cust_id=@cust_id;"; sqlObj.Param = dicParam; listSql.Add(sqlObj); } } catch (Exception ex) { LogService4Customer.WriteLog(1, ex); } }
/// <summary> /// 导入后更新维修单导入状态 /// </summary> /// <param name="strReservId">维修单Id</param> /// <param name="status">操作状体,0保存开放、1导入占用、2提交审核锁定</param> private void UpdateMaintainInfo(List <SQLObj> listSql, string strReservId, string status) { try { SQLObj obj = new SQLObj(); obj.cmdType = CommandType.Text; Dictionary <string, ParamObj> dicParam = new Dictionary <string, ParamObj>(); dicParam.Add("fetch_id", new ParamObj("fetch_id", strReservId, SysDbType.VarChar, 40)); if (status == Convert.ToInt32(DataSources.EnumImportStaus.OPEN).ToString()) { //保存时,前置单据被释放 dicParam.Add("import_status", new ParamObj("import_status", Convert.ToInt32(DataSources.EnumImportStaus.OPEN).ToString(), SysDbType.VarChar, 40));//开放 obj.sqlString = "update tb_maintain_fetch_material set import_status=@import_status where fetch_id=@fetch_id"; } else if (status == Convert.ToInt32(DataSources.EnumImportStaus.OCCUPY).ToString()) { //导入时,前置单据被占用 dicParam.Add("import_status", new ParamObj("import_status", "1", SysDbType.VarChar, 40));//占用 obj.sqlString = "update tb_maintain_fetch_material set import_status=@import_status where fetch_id=@fetch_id"; } else if (status == Convert.ToInt32(DataSources.EnumImportStaus.LOCK).ToString()) { //审核提交时,前置单据被锁定 dicParam.Add("import_status", new ParamObj("import_status", Convert.ToInt32(DataSources.EnumImportStaus.LOCK).ToString(), SysDbType.VarChar, 40));//锁定 obj.sqlString = "update tb_maintain_fetch_material set import_status=@import_status where fetch_id=@fetch_id"; } obj.Param = dicParam; listSql.Add(obj); } catch (Exception ex) { HXCPcClient.GlobalStaticObj.GlobalLogService.WriteLog(ex); } }
//撤回 void UC_RevokeEvent(object sender, EventArgs e) { if (MessageBoxEx.Show("确认要撤回该公告吗?", "提示", MessageBoxButtons.OKCancel) != DialogResult.OK) { return; } List <SQLObj> listSql = new List <SQLObj>(); SQLObj obj = new SQLObj(); obj.cmdType = CommandType.Text; Dictionary <string, ParamObj> dicParam = new Dictionary <string, ParamObj>(); dicParam.Add("announcement_id", new ParamObj("announcement_id", this.dr["announcement_id"], SysDbType.VarChar, 40)); //单据ID dicParam.Add("status", new ParamObj("status", DataSources.EnumAuditStatus.DRAFT.ToString("d"), SysDbType.VarChar, 40)); //单据状态 obj.sqlString = "update sys_announcement set status=@status where announcement_id=@announcement_id"; obj.Param = dicParam; listSql.Add(obj); if (DBHelper.BatchExeSQLMultiByTrans("更新单据状态为草稿", listSql)) { MessageBoxEx.Show("撤回成功!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); this.dr["status"] = DataSources.EnumAuditStatus.DRAFT.ToString("d"); this.btnRevoke.Enabled = false; this.btnVerify.Enabled = true; } else { MessageBoxEx.Show("撤回失败!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
/// <summary> 加载提醒 /// </summary> private static void LoadReminder() { //判断是否具有提醒功能 DataTable dt = DBHelper.GetTable("获取提醒设置", "sys_reminding_set", "*", string.Format("user_id='{0}'", GlobalStaticObj.UserID), "", ""); if (dt == null || dt.Rows.Count == 0) { return; } StringBuilder sb = new StringBuilder(); string project = string.Empty; foreach (DataRow dr in dt.Rows) { project = dr["projec"].ToString(); if (project == DataSources.EnumReminderType.YYDZ.ToString()) { sb.Append(string.Format("select * from tb_maintain_reservation where document_status='{0}' and enable_flag='{1}' and maintain_time>'{2}' and maintain_time<'{3}' order by update_time desc" , DataSources.EnumAuditStatus.AUDIT.ToString("d"), DataSources.EnumEnableFlag.USING.ToString("d"), Common.LocalDateTimeToUtcLong(DateTime.Now), Common.LocalDateTimeToUtcLong(DateTime.Now.AddMonths(1)))); sb.Append(";"); } else if (project == DataSources.EnumReminderType.DPG.ToString()) { sb.Append(string.Format("select * from tb_maintain_info where info_status='{0}' and enable_flag='{1}' and update_time>'{2}' and update_time<'{3}' order by update_time desc" , DataSources.EnumDispatchStatus.NotStartWork.ToString("d"), DataSources.EnumEnableFlag.USING.ToString("d"))); sb.Append(";"); } else if (project == DataSources.EnumReminderType.SBFWDBH.ToString()) { //三包服务驳回提醒 sb.Append(string.Format("select * from tb_maintain_three_guaranty where info_status='{0}' and enable_flag='{1}' and update_time>'{2}' and update_time<'{3}'" , DataSources.EnumDispatchStatus.NotStartWork.ToString("d") , DataSources.EnumEnableFlag.USING.ToString("d") , Common.LocalDateTimeToUtcLong(DateTime.Now) , Common.LocalDateTimeToUtcLong(DateTime.Now.AddDays(1)))); sb.Append(";"); } } if (sb.ToString().Length == 0) { return; } SQLObj sql = new SQLObj(); sql.Param = new Dictionary <string, SYSModel.ParamObj>(); sql.cmdType = CommandType.Text; sql.sqlString = sb.ToString(); DsReminder = DBHelper.GetDataSet("获取提醒", sql); if (ReminderComplated != null && DsReminder != null) { ReminderComplated(DsReminder); } }
private void SaveMaterialsData(List <SQLObj> listSql, string partID) { foreach (DataGridViewRow dgvr in dgvMaterials.Rows) { string strPname = CommonCtrl.IsNullToString(dgvr.Cells["parts_name"].Value); string strPCmoney = CommonCtrl.IsNullToString(dgvr.Cells["parts_code"].Value); if (strPname.Length > 0 && strPCmoney.Length > 0) { SQLObj obj = new SQLObj(); obj.cmdType = CommandType.Text; Dictionary <string, ParamObj> dicParam = new Dictionary <string, ParamObj>(); dicParam.Add("maintain_id", new ParamObj("maintain_id", partID, SysDbType.VarChar, 40)); dicParam.Add("parts_code", new ParamObj("parts_code", dgvr.Cells["parts_code"].Value, SysDbType.VarChar, 40)); dicParam.Add("parts_name", new ParamObj("parts_name", dgvr.Cells["parts_name"].Value, SysDbType.VarChar, 40)); dicParam.Add("orders_no", new ParamObj("orders_no", dgvr.Cells["orders_no"].Value, SysDbType.VarChar, 40)); dicParam.Add("vehicle_no", new ParamObj("vehicle_no", dgvr.Cells["vehicle_no"].Value, SysDbType.VarChar, 40)); dicParam.Add("unit", new ParamObj("unit", dgvr.Cells["unit"].Value, SysDbType.VarChar, 20)); dicParam.Add("drawn_no", new ParamObj("drawn_no", dgvr.Cells["drawn_no"].Value, SysDbType.VarChar, 40)); dicParam.Add("quantity", new ParamObj("quantity", !string.IsNullOrEmpty(CommonCtrl.IsNullToString(dgvr.Cells["quantity"].Value)) ? dgvr.Cells["quantity"].Value : null, SysDbType.Decimal, 15)); dicParam.Add("unit_price", new ParamObj("unit_price", !string.IsNullOrEmpty(CommonCtrl.IsNullToString(dgvr.Cells["unit_price"].Value)) ? dgvr.Cells["unit_price"].Value : null, SysDbType.Decimal, 15)); dicParam.Add("sum_money", new ParamObj("sum_money", !string.IsNullOrEmpty(CommonCtrl.IsNullToString(dgvr.Cells["sum_money"].Value)) ? dgvr.Cells["sum_money"].Value : null, SysDbType.Decimal, 15)); string strIsimport = CommonCtrl.IsNullToString(dgvr.Cells["whether_imported"].Value); if (!string.IsNullOrEmpty(strIsimport)) { dicParam.Add("whether_imported", new ParamObj("whether_imported", strIsimport == "是" ? "1" : "0", SysDbType.VarChar, 1)); } else { dicParam.Add("whether_imported", new ParamObj("whether_imported", null, SysDbType.VarChar, 1)); } dicParam.Add("vehicle_brand", new ParamObj("vehicle_brand", dgvr.Cells["vehicle_brand"].Value, SysDbType.VarChar, 40)); dicParam.Add("remarks", new ParamObj("remarks", dgvr.Cells["remarks"].Value, SysDbType.VarChar, 200)); dicParam.Add("enable_flag", new ParamObj("enable_flag", "1", SysDbType.VarChar, 1)); string strPID = CommonCtrl.IsNullToString(dgvr.Cells["parts_id"].Value); if (strPID.Length == 0) { opName = "新增旧件收货单"; strPID = Guid.NewGuid().ToString(); dicParam.Add("parts_id", new ParamObj("parts_id", strPID, SysDbType.VarChar, 40)); obj.sqlString = @"insert into tb_maintain_oldpart_material_detail (maintain_id,parts_code,parts_name,orders_no,vehicle_no,unit,drawn_no,quantity,unit_price ,sum_money,whether_imported,vehicle_brand,remarks,enable_flag,parts_id) values (@maintain_id,@parts_code,@parts_name,@orders_no,@vehicle_no,@unit,@drawn_no,@quantity,@unit_price ,@sum_money,@whether_imported,@vehicle_brand,@remarks,@enable_flag,@parts_id);"; } else { dicParam.Add("parts_id", new ParamObj("parts_id", dgvr.Cells["parts_id"].Value, SysDbType.VarChar, 40)); opName = "更新领料退货单"; obj.sqlString = @"update tb_maintain_oldpart_material_detail set maintain_id=@maintain_id,parts_code=@parts_code,parts_name=@parts_name,orders_no=@orders_no,vehicle_no=@vehicle_no,unit=@unit,drawn_no=@drawn_no,quantity=@quantity,unit_price=@unit_price ,sum_money=@sum_money,whether_imported=@whether_imported,vehicle_brand=@vehicle_brand,remarks=@remarks,enable_flag=@enable_flag where parts_id=@parts_id"; } obj.Param = dicParam; listSql.Add(obj); } } }