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);
}
}
}
