/// <summary>
/// 公司组织树
/// </summary>
private void BindTree()
{
string strSql = "select '0' as ftype, c.com_id as id,c.parent_id,'' as ocom_id,c.com_code as code,c.com_name as name from tb_company c where c.enable_flag ='1' union all "
+ "select '1' as ftype, o.org_id as id,o.parent_id,o.com_id as ocom_id,o.org_code as code,o.org_name as name from tb_company c,tb_organization o where "
+ " c.enable_flag ='1' and o.enable_flag='1' and c.com_id=o.com_id ";
SYSModel.SQLObj sqlobj = new SYSModel.SQLObj();
sqlobj.cmdType = CommandType.Text;
sqlobj.Param = new Dictionary<string, SYSModel.ParamObj>();
sqlobj.sqlString = strSql;
DataSet ds = DBHelper.GetDataSet("查询公司组织树", sqlobj);
tvCompany.Nodes.Clear();
//节点加上去
if (ds.Tables[0].Rows.Count > 0)
{
//clsGetTree cls = new clsGetTree();
CommonCtrl.InitTree(this.tvCompany.Nodes, "-1", ds.Tables[0].DefaultView);
if (tvCompany.Nodes.Count > 0)
{
tvCompany.Nodes[0].Expand();
}
}
}
void UCVehicleView_StatusEvent(object sender, EventArgs e)
{
List<SQLObj> listSql = new List<SQLObj>();
SQLObj obj = new SQLObj();
obj.cmdType = CommandType.Text;
Dictionary<string, ParamObj> dicParam = new Dictionary<string, ParamObj>();
string strMsg = string.Empty;
if (strStatus == Convert.ToInt32(DataSources.EnumStatus.Start).ToString())
{
strMsg = "停用";
dicParam.Add("status", new ParamObj("status", DataSources.EnumStatus.Stop, SysDbType.VarChar, 40));//状态
}
else if (strStatus == Convert.ToInt32(DataSources.EnumStatus.Stop).ToString())
{
strMsg = "启用";
dicParam.Add("status", new ParamObj("status", DataSources.EnumStatus.Start, SysDbType.VarChar, 40));//状态
}
if (MessageBoxEx.Show("确认要" + strMsg + "吗?", "提示", MessageBoxButtons.OKCancel) != DialogResult.OK)
{
return;
}
dicParam.Add("v_id", new ParamObj("v_id", strVId, SysDbType.VarChar, 40));//车辆档案Id
dicParam.Add("update_by", new ParamObj("update_by", HXCPcClient.GlobalStaticObj.UserID, SysDbType.VarChar, 40));//修改人Id
dicParam.Add("update_time", new ParamObj("update_time", Common.LocalDateTimeToUtcLong(HXCPcClient.GlobalStaticObj.CurrentDateTime).ToString(), SysDbType.BigInt));//修改时间
obj.sqlString = "update tb_vehicle set status=@status,update_by=@update_by,update_time=@update_time where v_id=@v_id";
obj.Param = dicParam;
listSql.Add(obj);
if (DBHelper.BatchExeSQLMultiByTrans("更新单据状态为启停用", listSql))
{
MessageBoxEx.Show("" + strMsg + "成功！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
uc.BindPageData();
deleteMenuByTag(this.Tag.ToString(), this.uc.Name);
}
}
/// <summary>
/// 公司组织树
/// </summary>
private void BindTree()
{
string strSql = "select '0' as ftype, c.com_id as id,c.parent_id,'' as ocom_id,c.com_code as code,c.com_name as name from tb_company c where c.enable_flag ='1' union all "
+ "select '1' as ftype, o.org_id as id,o.parent_id,o.com_id as ocom_id,o.org_code as code,o.org_name as name from tb_company c,tb_organization o where "
+ " c.enable_flag ='1' and o.enable_flag='1' and c.com_id=o.com_id ";
SYSModel.SQLObj sqlobj = new SYSModel.SQLObj();
sqlobj.cmdType = CommandType.Text;
sqlobj.Param = new Dictionary <string, SYSModel.ParamObj>();
sqlobj.sqlString = strSql;
DataSet ds = DBHelper.GetDataSet("查询公司组织树", sqlobj);
tvCompany.Nodes.Clear();
//节点加上去
if (ds.Tables[0].Rows.Count > 0)
{
//clsGetTree cls = new clsGetTree();
CommonCtrl.InitTree(this.tvCompany.Nodes, "-1", ds.Tables[0].DefaultView);
if (tvCompany.Nodes.Count > 0)
{
tvCompany.Nodes[0].Expand();
tvCompany.SelectedNode = tvCompany.Nodes[0];
}
}
}
/// <summary> 公司组织树
/// </summary>
private void BindTree()
{
tvCompany.Nodes.Clear();
string strSql = "select '0' as ftype, c.com_id as id,c.parent_id,'' as ocom_id,c.com_code as code,c.com_name as name from tb_company c where c.enable_flag ='1' and (c.data_source is null or c.data_source!=" + DataSources.EnumDataSources.YUTONG.ToString("d") + ") union all "
+ "select '1' as ftype, o.org_id as id,o.parent_id,o.com_id as ocom_id,o.org_code as code,o.org_name as name from tb_company c,tb_organization o where "
+ " c.enable_flag ='1' and o.enable_flag='1' and c.com_id=o.com_id ";
SYSModel.SQLObj sqlobj = new SYSModel.SQLObj();
sqlobj.cmdType = CommandType.Text;
sqlobj.Param = new Dictionary <string, SYSModel.ParamObj>();
sqlobj.sqlString = strSql;
DataSet ds = DBHelper.GetDataSet("查询公司组织树", GlobalStaticObj_Server.DbPrefix + GlobalStaticObj_Server.CommAccCode, sqlobj);
//DataTable dt = DBHelper.GetTable("获取根公司", GlobalStaticObj_Server.DbPrefix + GlobalStaticObj_Server.CommAccCode, "tb_company", "*", "data_source=" + DataSources.EnumDataSources.YUTONG.ToString("d"), "", "");
string rootid = "-1";
tvCompany.Nodes.Add(rootid, "所有");
//节点加上去
if (ds.Tables[0].Rows.Count > 0)
{
CommonCtrl.InitTree(tvCompany.Nodes[0].Nodes, rootid, ds.Tables[0].DefaultView);
}
if (tvCompany.Nodes.Count > 0)
{
tvCompany.Nodes[0].Expand();
tvCompany.SelectedNode = tvCompany.Nodes[0];
tvCompany.SelectedNode.Expand();
}
}
/// <summary>
/// 获取菜单权限
/// </summary>
/// <param name="fun_id">菜单id</param>
private void GetRoleFun(string fun_id)
{
DataSet ds = new DataSet();
string strSql = " with fun as( select * from sys_function where fun_id = '" + fun_id + "' union all "
+ "select sf.* from fun f inner join sys_function sf on f.fun_id = sf.parent_id ) "
+ "select fun.fun_id,fun.num,fun.fun_name,fun.fun_ename,fun.fun_uri ,fun.fun_img,fun.parent_id,fun.fun_cbs ,fun.fun_level ,fun.fun_idx ,fun.fun_flag ,fun.fun_run "
+ " ,CONVERT(bit,rf.button_browse) button_browse,CONVERT(bit,rf.button_add) button_add ,CONVERT(bit,rf.button_edit)button_edit "
+ " ,CONVERT(bit,rf.button_copy )button_copy ,CONVERT(bit,rf.button_delete)button_delete,CONVERT(bit,rf.button_cancel) button_cancel "
+ " ,CONVERT(bit,rf.button_activate) button_activate,CONVERT(bit,rf.button_enable) button_enable,CONVERT(bit,rf.button_disable) button_disable "
+ " ,CONVERT(bit,rf.button_save) button_save ,CONVERT(bit,rf.button_submit) button_submit ,CONVERT(bit,rf.button_examine) button_examine,CONVERT(bit,rf.button_import) button_import "
+ " ,CONVERT(bit,rf.button_export) button_export ,CONVERT(bit,rf.button_print) button_print ,CONVERT(bit,rf.button_operation_record)button_operation_record "
+ " ,CONVERT(bit,rf.button_dispatching) button_dispatching ,CONVERT(bit,rf.button_settle_accounts) button_settle_accounts "
+ " ,fun.enable_flag ,fun.remark ,fun.create_by,fun.create_time,fun.update_by ,fun.update_time,CONVERT(bit, '0') as isall "
+ " from fun ,tr_role_function rf,sys_role sr where rf.role_id =sr.role_id and rf.fun_id=fun.fun_id and sr.role_id='" + id + "' "
+ " and fun.fun_run='1' and fun.fun_flag='1' and fun.enable_flag='1' ";
SYSModel.SQLObj sobj = new SYSModel.SQLObj();
sobj.cmdType = CommandType.Text;
sobj.Param = new Dictionary <string, SYSModel.ParamObj>();
sobj.sqlString = strSql;
ds = DBHelper.GetDataSet("查询角色权限", sobj);
if (ds != null && ds.Tables.Count > 0)
{
dgvFunction.DataSource = ds.Tables[0].DefaultView;
}
}
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);
SetSysManageViewBtn();
}
/// <summary>
/// 获取菜单权限
/// </summary>
/// <param name="fun_id">菜单id</param>
private void GetRoleFun(string fun_id)
{
DataSet ds = new DataSet();
string strSql = " with fun as( select * from sys_function where fun_id = '" + fun_id + "' union all "
+ "select sf.* from fun f inner join sys_function sf on f.fun_id = sf.parent_id ) "
+ "select fun.fun_id,fun.num,fun.fun_name,fun.fun_ename,fun.fun_uri ,fun.fun_img,fun.parent_id,fun.fun_cbs ,fun.fun_level ,fun.fun_idx ,fun.fun_flag ,fun.fun_run, "
+ "CONVERT (bit, rf.button_add) button_add,"
+ "CONVERT (bit, rf.button_edit) button_edit,"
+ "CONVERT (bit, rf.button_delete) button_delete,"
+ "CONVERT (bit, rf.button_save) button_save,"
+ "CONVERT (bit, rf.button_cancel) button_cancel,"
+ "CONVERT (bit, rf.button_view) button_view,"
+ "CONVERT (bit, rf.button_status) button_status,"
+ "CONVERT (bit, rf.button_backup) button_backup,"
+ "CONVERT (bit, rf.button_restore) button_restore,"
+ "CONVERT (bit, rf.button_import) button_import,"
+ "CONVERT (bit, rf.button_export) button_export,"
+ "CONVERT (bit, rf.button_print) button_print,"
+ "CONVERT (bit, rf.button_preview) button_preview,"
+ "CONVERT (bit, rf.button_sync) button_sync,"
+ "CONVERT (bit, rf.button_oprecord) button_oprecord,"
+ " fun.enable_flag ,fun.remark ,fun.create_by,fun.create_time,fun.update_by ,fun.update_time,CONVERT(bit, '0') as isall "
+ " from fun ,tr_role_function rf,sys_role sr where rf.role_id =sr.role_id and rf.fun_id=fun.fun_id and sr.role_id='" + id + "' "
+ " and fun.fun_run='1' and fun.fun_flag='1' and fun.enable_flag='1' ";
SYSModel.SQLObj sobj = new SYSModel.SQLObj();
sobj.cmdType = CommandType.Text;
sobj.Param = new Dictionary <string, SYSModel.ParamObj>();
sobj.sqlString = strSql;
ds = DBHelper.GetDataSet("查询角色权限", GlobalStaticObj_Server.DbPrefix + GlobalStaticObj_Server.CommAccCode, sobj);
dgvFunction.DataSource = ds.Tables[0].DefaultView;
}
/// <summary>
/// 获取预收/付余额
/// </summary>
/// <param name="custID">往来单位单位ID</param>
/// <param name="orderType">单据类型</param>
/// <returns></returns>
public static decimal GetAdvance(string custID, DataSources.EnumOrderType orderType)
{
SYSModel.SQLObj sql = new SYSModel.SQLObj();
sql.cmdType = CommandType.StoredProcedure;
if (orderType == DataSources.EnumOrderType.PAYMENT)
{
sql.sqlString = "p_yufu_yu_e";
}
else
{
sql.sqlString = "p_yushou_yu_e";
}
sql.Param = new Dictionary <string, ParamObj>();
sql.Param.Add("cust_id", new ParamObj("cust_id", custID, SysDbType.VarChar, 40));
DataSet ds = DBHelper.GetDataSet("查询往来余额", sql);
if (ds == null || ds.Tables.Count == 0 || ds.Tables[0].Rows.Count == 0 || ds.Tables[0].Rows[0][0] == DBNull.Value)
{
return(0);
}
else
{
return(Convert.ToDecimal(ds.Tables[0].Rows[0][0]));
}
}
private void UCOrganizationView_Load(object sender, EventArgs e)
{
//base.RoleButtonStstus(uc.Name);//角色按钮权限-是否隐藏
//base.SetBtnStatus(wStatus);
DataSources.BindComBoxDataEnum(cbostate, typeof(DataSources.EnumStatus), true);//绑定状态 启用 停用
BindTree();
// string strSql = "SELECT o.*,(select USER_NAME from sys_user where user_id =o.create_by )as create_Username , "
//+ "(select USER_NAME from sys_user where user_id =o.update_by ) as update_username FROM tb_organization o where org_id='" + id + "'";
//SELECT o.*,(select USER_NAME from sys_user where user_id =o.create_by )as create_Username ,
//(select USER_NAME from sys_user where user_id =o.update_by ) as update_username ,
//po.org_code as parentcode,po.org_name as parentname ,c.com_name ,c.com_code FROM tb_organization o
//left join tb_organization po on o.parent_id=po.org_id
//left join tb_company c on o.com_id=c.com_id
//where o.org_id='8b4471da-b9bd-4d59-b3f1-af1841dc3ab5'
string strSql = "SELECT o.*,(select USER_NAME from sys_user where user_id =o.create_by )as create_Username,";
strSql += "(select USER_NAME from sys_user where user_id =o.update_by ) as update_username ,";
strSql += "po.org_code as parentcode,po.org_name as parentname ,c.com_name ,c.com_code FROM tb_organization o ";
strSql += "left join tb_organization po on o.parent_id=po.org_id ";
strSql += "left join tb_company c on o.com_id=c.com_id ";
strSql += "where o.org_id='" + id + "'";
SQLObj sqlobj = new SQLObj();
sqlobj.cmdType = CommandType.Text;
sqlobj.Param = new Dictionary<string, ParamObj>();
sqlobj.sqlString = strSql;
DataSet ds = DBHelper.GetDataSet("查询组织", sqlobj);
//DBHelper.GetTable("查询组织", "tb_organization", "*", "org_id='" + id + "'", "", "");
if (ds == null || ds.Tables[0].Rows.Count <= 0)
{
MessageBoxEx.Show("查询组织失败！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
DataTable dt = ds.Tables[0];
CommonCtrl.SelectTreeView(tvCompany, dt.Rows[0]["parent_id"].ToString());
if (dt.Rows[0]["parentname"] != null && dt.Rows[0]["parentname"].ToString() != string.Empty)
{ lblporg_name.Text = dt.Rows[0]["parentname"].ToString(); }
else
{ lblporg_name.Text = CommonCtrl.IsNullToString(dt.Rows[0]["com_name"]); }
if (dt.Rows[0]["parentcode"] != null && dt.Rows[0]["parentcode"].ToString() != string.Empty)
{ lblporg_code.Text = dt.Rows[0]["parentcode"].ToString(); }
else
{ lblporg_code.Text = CommonCtrl.IsNullToString(dt.Rows[0]["com_code"]); }
lblorg_code.Text = dt.Rows[0]["org_code"].ToString();
lblorg_name.Text = dt.Rows[0]["org_name"].ToString();
lblorg_short_name.Text = dt.Rows[0]["org_short_name"].ToString();
lblremark.Text = dt.Rows[0]["remark"].ToString();
lblcontact_name.Text = dt.Rows[0]["contact_name"].ToString();
lblcontact_telephone.Text = dt.Rows[0]["contact_telephone"].ToString();
lblcreate_Username.Text = dt.Rows[0]["create_Username"].ToString();
lblcreate_time.Text = Common.UtcLongToLocalDateTime(Convert.ToInt64(dt.Rows[0]["create_time"].ToString())).ToString();
lblupdate_username.Text = dt.Rows[0]["update_username"].ToString();
lblupdate_time.Text = Common.UtcLongToLocalDateTime(Convert.ToInt64(dt.Rows[0]["update_time"].ToString())).ToString();
cbostate.SelectedValue = dt.Rows[0]["status"].ToString();
SetSysManageViewBtn();
}
private void UCRoleView_Load(object sender, EventArgs e)
{
// base.RoleButtonStstus(uc.Name);//角色按钮权限-是否隐藏
//base.SetBtnStatus(wStatus);
DataSources.BindComBoxDataEnum(cbostate, typeof(DataSources.EnumStatus), true); //绑定状态 启用 停用
DataSources.BindComBoxDataEnum(cbodata_sources, typeof(DataSources.EnumDataSources), true); //数据来源 自建 宇通
DataTable dt = DBHelper.GetTable("查询角色", "v_role", "*", "role_id='" + id + "'", "", "");
if (dt.Rows.Count <= 0)
{
MessageBoxEx.Show("查询角色失败！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
lblRole_code.Text = dt.Rows[0]["role_code"].ToString();
lblRole_name.Text = dt.Rows[0]["Role_name"].ToString();
lblremark.Text = dt.Rows[0]["remark"].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();
cbostate.SelectedValue = dt.Rows[0]["state"].ToString();
cbodata_sources.SelectedValue = dt.Rows[0]["data_sources"].ToString();
string strSql = "select u.user_id,u.user_code,u.user_name,u.user_phone,u.com_name,u.org_id,u.remark, u.org_name from v_User u ,tr_user_role ur,sys_role r "
+ " where u.user_id=ur.user_id and r.role_id=ur.role_id and r.enable_flag='1' and r.role_id='" + id + "' ";
SYSModel.SQLObj sqlobj = new SYSModel.SQLObj();
sqlobj.cmdType = CommandType.Text;
sqlobj.Param = new Dictionary <string, SYSModel.ParamObj>();
sqlobj.sqlString = strSql;
DataSet ds = DBHelper.GetDataSet("查询用户角色关系", sqlobj);
//dgvUser.DataSource = ds.Tables[0].DefaultView;
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
foreach (DataRow dr in ds.Tables[0].Rows)
{
DataGridViewRow gvr = dgvUser.Rows[dgvUser.Rows.Add()];
gvr.Cells["user_id"].Value = dr["user_id"];
gvr.Cells["user_code"].Value = dr["user_code"];
gvr.Cells["user_name"].Value = dr["user_name"];
gvr.Cells["com_name"].Value = dr["com_name"];
gvr.Cells["org_name"].Value = dr["org_name"];
gvr.Cells["user_phone"].Value = dr["user_phone"];
gvr.Cells["remark"].Value = dr["remark"];
}
}
bindTree();
GetRoleFun("CL_ROOT");
DataGridViewStyle.DataGridViewBgColor(dgvFunction);
DataGridViewStyle.DataGridViewBgColor(dgvUser);
SetSysBtnView();
}
void UCRepairRescueView_InvalidOrActivationEvent(object sender, EventArgs e)
{
string strmsg = string.Empty;
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("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 (strStatus != Convert.ToInt32(DataSources.EnumAuditStatus.Invalid).ToString())
{
strmsg = "作废";
dicParam.Add("document_status", new ParamObj("document_status", DataSources.EnumAuditStatus.Invalid, SysDbType.VarChar, 40));//单据状态
}
else
{
strmsg = "激活";
string OnStatus = "";
DataTable dvt = DBHelper.GetTable("获得前一个状态", "tb_maintain_rescue_info_BackUp", "document_status", "rescue_id='" + strRescueId + "'", "", "order by update_time desc");
if (dvt.Rows.Count > 0)
{
DataRow dr = dvt.Rows[0];
OnStatus = CommonCtrl.IsNullToString(dr["document_status"]);
if (OnStatus == Convert.ToInt32(DataSources.EnumAuditStatus.Invalid).ToString())
{
DataRow dr1 = dvt.Rows[1];
OnStatus = CommonCtrl.IsNullToString(dr1["document_status"]);
}
}
OnStatus = !string.IsNullOrEmpty(OnStatus) ? OnStatus : Convert.ToInt32(DataSources.EnumAuditStatus.DRAFT).ToString();
dicParam.Add("document_status", new ParamObj("document_status", OnStatus, SysDbType.VarChar, 40));//单据状态
}
obj.sqlString = "update tb_maintain_rescue_info set document_status=@document_status,update_by=@update_by,update_name=@update_name,update_time=@update_time where rescue_id=@rescue_id";
obj.Param = dicParam;
listSql.Add(obj);
if (MessageBoxEx.Show("确认要" + strmsg + "吗?", "提示", MessageBoxButtons.OKCancel) != DialogResult.OK)
{
return;
}
if (DBHelper.BatchExeSQLMultiByTrans("更新单据状态为" + strmsg + "", listSql))
{
MessageBoxEx.Show("" + strmsg + "成功！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
uc.BindPageData();
deleteMenuByTag(this.Tag.ToString(), "UCRepairRescueView");
}
else
{
MessageBoxEx.Show("" + strmsg + "失败！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
private void UCRoleView_Load(object sender, EventArgs e)
{
// base.RoleButtonStstus(uc.Name);//角色按钮权限-是否隐藏
//base.SetBtnStatus(wStatus);
DataSources.BindComBoxDataEnum(cbostate, typeof(DataSources.EnumStatus), true);//绑定状态 启用 停用
DataSources.BindComBoxDataEnum(cbodata_sources, typeof(DataSources.EnumDataSources), true);//数据来源 自建 宇通
DataTable dt = DBHelper.GetTable("查询角色", "v_role", "*", "role_id='" + id + "'", "", "");
if (dt.Rows.Count <= 0)
{
MessageBoxEx.Show("查询角色失败！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
lblRole_code.Text = dt.Rows[0]["role_code"].ToString();
lblRole_name.Text = dt.Rows[0]["Role_name"].ToString();
lblremark.Text = dt.Rows[0]["remark"].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();
cbostate.SelectedValue = dt.Rows[0]["state"].ToString();
cbodata_sources.SelectedValue = dt.Rows[0]["data_sources"].ToString();
string strSql = "select u.user_id,u.user_code,u.user_name,u.user_phone,u.com_name,u.org_id,u.remark, u.org_name from v_User u ,tr_user_role ur,sys_role r "
+ " where u.user_id=ur.user_id and r.role_id=ur.role_id and r.enable_flag='1' and r.role_id='" + id + "' ";
SYSModel.SQLObj sqlobj = new SYSModel.SQLObj();
sqlobj.cmdType = CommandType.Text;
sqlobj.Param = new Dictionary<string, SYSModel.ParamObj>();
sqlobj.sqlString = strSql;
DataSet ds = DBHelper.GetDataSet("查询用户角色关系", sqlobj);
//dgvUser.DataSource = ds.Tables[0].DefaultView;
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
foreach (DataRow dr in ds.Tables[0].Rows)
{
DataGridViewRow gvr = dgvUser.Rows[dgvUser.Rows.Add()];
gvr.Cells["user_id"].Value = dr["user_id"];
gvr.Cells["user_code"].Value = dr["user_code"];
gvr.Cells["user_name"].Value = dr["user_name"];
gvr.Cells["com_name"].Value = dr["com_name"];
gvr.Cells["org_name"].Value = dr["org_name"];
gvr.Cells["user_phone"].Value = dr["user_phone"];
gvr.Cells["remark"].Value = dr["remark"];
}
}
bindTree();
GetRoleFun("CL_ROOT");
DataGridViewStyle.DataGridViewBgColor(dgvFunction);
DataGridViewStyle.DataGridViewBgColor(dgvUser);
SetSysBtnView();
}
private void _LoadData(object obj)
{
string strSql = "select u.user_id,u.user_code,u.user_name,u.user_phone,u.com_name,u.org_id,u.remark,u.org_name from v_User u ,tr_user_role ur,sys_role r "
+ " where u.user_id=ur.user_id and r.role_id=ur.role_id and r.enable_flag='1' and r.role_id='" + id + "' ";
SYSModel.SQLObj sqlobj = new SYSModel.SQLObj();
sqlobj.cmdType = CommandType.Text;
sqlobj.Param = new Dictionary <string, SYSModel.ParamObj>();
sqlobj.sqlString = strSql;
DataSet ds = DBHelper.GetDataSet("查询用户角色关系", sqlobj);
this.Invoke(this.uiHandler, ds);
}
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>
/// <returns>公司组织信息</returns>
private static DataSet GetComOrg()
{
string strSql = "select '0' as ftype, c.com_id as id,c.parent_id,'' as ocom_id,c.com_code as code,c.com_name as name from tb_company c where c.enable_flag ='1' union all "
+ "select '1' as ftype, o.org_id as id,o.parent_id,o.com_id as ocom_id,o.org_code as code,o.org_name as name from tb_company c,tb_organization o where "
+ " c.enable_flag ='1' and o.enable_flag='1' and c.com_id=o.com_id and c.status=1";
SYSModel.SQLObj sqlobj = new SYSModel.SQLObj();
sqlobj.cmdType = CommandType.Text;
sqlobj.Param = new Dictionary <string, SYSModel.ParamObj>();
sqlobj.sqlString = strSql;
DataSet ds = DBHelper.GetDataSet("查询公司组织树", sqlobj);
return(ds);
}
private void Init()
{
SetFuncationButtonVisible();
SetSettlementInfo();
SetServiceInfo();
SetSettlementOldInfo();
SetSettlementOtherInfo();
SetSettlementInventoryInfo();
#region 确认
btnConfirm.Click += delegate
{
var info = DBHelper.GetTable("查询结算单信息", "tb_maintain_three_guaranty_settlement", "*",
"st_id = '" + SettlementId + "'", "", "");
if (info != null && info.DefaultView.Count != 0)
{
foreach (DataRowView dr in info.DefaultView)
{
if (dr["info_status"].ToString() == DbDic2Enum.SYS_STATION_SETTLEMENT_STATUS_CONFIRM) continue;
var stId = dr["st_id"].ToString();
var sqlObjList = new List<SQLObj>();
var sqlObj = new SQLObj
{
cmdType = CommandType.Text,
sqlString =
"update tb_maintain_three_guaranty_settlement set info_status=@info_status where st_id=@st_id",
Param = new Dictionary<string, ParamObj>
{
{
"info_status",
new ParamObj
{
name = "info_status",
value = DbDic2Enum.SYS_STATION_SETTLEMENT_STATUS_CONFIRM
}
},
{"st_id", new ParamObj {name = "st_id", value = stId}}
}
};
UIAssistants.SetParamObjInfoByDB("tb_maintain_three_guaranty_settlement", sqlObj.Param);
sqlObjList.Add(sqlObj);
DBHelper.BatchExeSQLMultiByTrans("结算单信息确认", sqlObjList);
}
}
};
#endregion
}
public static DataView GetIsUsePreOrder(String preOrdeName, String preOrderColumnName, String postOrderName, String where)
{
if (String.IsNullOrEmpty(where)) where = "1=1";
var sqlStr = String.Format("select cc.* from (select bb.pre_order_id as tempcolum, bb.status, bb.post_order_name, aa.* from {0} aa left join tr_order_relation bb on aa.{1}=bb.pre_order_id) as cc where cc.tempcolum is null and (cc.post_order_name != '{2}' or cc.post_order_name is null) and {3}", preOrdeName, preOrderColumnName, postOrderName, where);
var sqlObj = new SQLObj
{
cmdType = CommandType.Text,
sqlString = sqlStr,
Param = new Dictionary<string, ParamObj>()
};
var dt = DBHelper.GetDataSet(String.Format("获取未被{0}占用的{1}单据", postOrderName, preOrdeName), sqlObj);
if (dt == null || dt.Tables.Count < 1 || dt.Tables[0].DefaultView == null) return null;
return dt.Tables[0].DefaultView;
}
public static DataView GetIsUsePreOrder(String preOrdeName, String preOrderColumnName, String postOrderName, String where)
{
if (String.IsNullOrEmpty(where)) where = "1=1";
var sqlStr = String.Format("select distinct bb.pre_order_id, bb.status, bb.post_order_name, aa.*,case when len(bb.post_item_order_name)>1 then '1' else bb.post_item_order_name end post_item_order_name from {0} aa left join tr_order_relation bb on aa.{1}=bb.pre_order_id where ((bb.pre_order_id is null and (bb.post_order_name != '{2}' or bb.post_order_name is null)) or (bb.post_order_name = '{2}' and bb.post_item_order_name is not null)) and {3}", preOrdeName, preOrderColumnName, postOrderName, where);
var sqlObj = new SQLObj
{
cmdType = CommandType.Text,
sqlString = sqlStr,
Param = new Dictionary<string, ParamObj>()
};
var dt = DBHelper.GetDataSet(String.Format("获取未被{0}占用的{1}单据", postOrderName, preOrdeName), sqlObj);
if (dt == null || dt.Tables.Count < 1 || dt.Tables[0].DefaultView == null) return null;
return dt.Tables[0].DefaultView;
}
private static DataTable Organization()
{
string strsql = "select c.com_code,c.com_name,o.org_code,o.org_name,o.org_id,c.legal_person,c.com_contact,c.com_tel,o.contact_name,o.contact_telephone "
+ " from tb_organization o left join tb_company c on o.com_id=c.com_id where c.enable_flag='1' and o.enable_flag='1' ";
strsql += " order by c.com_name";
SYSModel.SQLObj sqlobj = new SYSModel.SQLObj();
sqlobj.cmdType = CommandType.Text;
sqlobj.Param = new Dictionary <string, SYSModel.ParamObj>();
sqlobj.sqlString = strsql;
DataTable ds = DBHelper.GetDataSet("查询组织-组织选择器", sqlobj).Tables[0];
return(ds);
}
private void _LoadData(object obj)
{
SQLObj sqlobj = new SQLObj();
sqlobj.cmdType = CommandType.Text;
sqlobj.Param = new Dictionary<string, ParamObj>();
sqlobj.sqlString = "SELECT p.*,w.project_name,w.project_num,w.quota_price,'' as discount_price FROM tb_CustomerSer_member_setInfo_projrct p left join tb_workhours w on w.whours_id=p.service_project_id "
+ " where p.enable_flag='1' and p.setInfo_id='" + id + "'";
sqlobj.sqlString += "; SELECT p2.*,w2.ser_parts_code,w2.parts_name,w3.ref_out_price,'' as discount_price FROM tb_CustomerSer_member_setInfo_parts p2 left join tb_parts w2 on w2.parts_id = p2.parts_id left join tb_parts_price w3 on w3.parts_id=p2.parts_id "
+ " where p2.enable_flag='1' and p2.setInfo_id='" + id + "'";
DataSet ds = DBHelper.GetDataSet("", sqlobj);
this.Invoke(this.uiHandler, ds);
}
void BindStock(string parts_id)
{
StringBuilder sbWhere = new StringBuilder();
sbWhere.AppendFormat("stock_part_id='{0}'", parts_id);
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>
private void BindTree()
{
string strSql = "select '0' as ftype, c.com_id as id,c.parent_id,'' as ocom_id,c.com_code as code,c.com_name as name from tb_company c where c.enable_flag ='1' union all "
+ "select '1' as ftype, o.org_id as id,o.parent_id,o.com_id as ocom_id,o.org_code as code,o.org_name as name from tb_company c,tb_organization o where "
+ " c.enable_flag ='1' and o.enable_flag='1' and c.com_id=o.com_id and c.status=1 and o.status=1";
SYSModel.SQLObj sqlobj = new SYSModel.SQLObj();
sqlobj.cmdType = CommandType.Text;
sqlobj.Param = new Dictionary <string, SYSModel.ParamObj>();
sqlobj.sqlString = strSql;
dscom = DBHelper.GetDataSet("查询公司组织树", sqlobj);
tvCompany.Nodes.Clear();
TreeNode tmpNd = new TreeNode();
//获取根公司信息
DataTable comDT = DBHelper.GetTable("获取根公司", GlobalStaticObj.CommAccCode, "tb_company", "*", " data_source='" + DataSources.EnumDataSources.YUTONG.ToString("d") + "'", string.Empty, string.Empty);
if (comDT != null && comDT.Rows.Count > 0)
{
tmpNd.Text = comDT.Rows[0]["com_name"].ToString(); //name
tmpNd.Name = comDT.Rows[0]["com_id"].ToString(); //id
}
else
{
tmpNd.Text = "全部"; //name
tmpNd.Name = "Root"; //id
}
tvCompany.Nodes.Add(tmpNd);
//节点加上去
if (dscom != null && dscom.Tables[0].Rows.Count > 0)
{
//clsGetTree cls = new clsGetTree();
//CL_ROOT
//CommonCtrl.InitTree(this.tvCompany.Nodes, "-1", ds.Tables[0].DefaultView);
InitTree(tmpNd.Nodes, "-1", dscom.Tables[0].DefaultView);
if (tvCompany.Nodes.Count > 0)
{
tvCompany.Nodes[0].Expand();
tvCompany.SelectedNode = tvCompany.Nodes[0];
}
}
}
/// <summary>
/// 查询绑定会员参数设置特殊维修项目折扣
/// </summary>
private void BindDgvProjrct()
{
SQLObj sqlobj = new SQLObj();
sqlobj.cmdType = CommandType.Text;
sqlobj.Param = new Dictionary<string, ParamObj>();
sqlobj.sqlString = "SELECT p.*,w.project_name,w.project_num,w.quota_price,'' as discount_price FROM tb_CustomerSer_member_setInfo_projrct p left join tb_workhours w on w.whours_id=p.service_project_id "
+ " where p.enable_flag='1' and p.setInfo_id='" + id + "'";
DataSet dsProjrct = DBHelper.GetDataSet("查询会员参数设置特殊维修项目折扣", sqlobj);
if (dsProjrct != null && dsProjrct.Tables[0].Rows.Count > 0)
{
foreach (DataRow dr in dsProjrct.Tables[0].Rows)
{
DataGridViewRow row = dgvprojrct.Rows[dgvprojrct.Rows.Add()];
row.Cells["project_num"].Value = dr["project_num"].ToString();
row.Cells["project_name"].Value = dr["project_name"].ToString();
row.Cells["quota_price"].Value = dr["quota_price"].ToString();
row.Cells["project_service_project_discount"].Value = dr["service_project_discount"].ToString();
row.Cells["project_remark"].Value = dr["remark"].ToString();
row.Cells["service_project_id"].Value = dr["service_project_id"].ToString();
row.Cells["p_setInfo_id"].Value = dr["setInfo_id"].ToString();
row.Cells["setInfo_projrct_id"].Value = dr["id"].ToString();
if (dr["service_project_discount"].ToString() != "")
{
int iValue = Convert.ToInt32(dr["service_project_discount"].ToString());
bool bln = false;
decimal quota_price = 0;
string strquota_price = Utility.Common.Validator.IsDecimal(dr["quota_price"].ToString(), 10, 2, ref bln);
if (bln)
{
quota_price = Convert.ToDecimal(strquota_price);
decimal discount_price = Math.Abs(Math.Round((quota_price * iValue) / 100, 2));
row.Cells["project_discount_price"].Value = discount_price.ToString();
}
else
{
row.Cells["project_discount_price"].Value = "";
}
}
}
}
}
/// <summary>
/// 获取预收/付余额
/// </summary>
/// <param name="custID">往来单位单位ID</param>
/// <param name="orderType">单据类型</param>
/// <returns></returns>
public static decimal GetAdvance(string custID, DataSources.EnumOrderType orderType)
{
SYSModel.SQLObj sql = new SYSModel.SQLObj();
sql.cmdType = CommandType.StoredProcedure;
if (orderType == DataSources.EnumOrderType.PAYMENT)
{
sql.sqlString = "p_yufu_yu_e";
}
else
{
sql.sqlString = "p_yushou_yu_e";
}
sql.Param = new Dictionary<string, ParamObj>();
sql.Param.Add("cust_id", new ParamObj("cust_id", custID, SysDbType.VarChar, 40));
DataSet ds = DBHelper.GetDataSet("查询往来余额", sql);
if (ds == null || ds.Tables.Count == 0 || ds.Tables[0].Rows.Count == 0 || ds.Tables[0].Rows[0][0] == DBNull.Value)
{
return 0;
}
else
{
return Convert.ToDecimal(ds.Tables[0].Rows[0][0]);
}
}
private void UCOrganizationView_Load(object sender, EventArgs e)
{
//base.RoleButtonStstus(uc.Name);//角色按钮权限-是否隐藏
base.SetBtnStatus(wStatus);
DataSources.BindComBoxDataEnum(cbostate, typeof(DataSources.EnumStatus), true);//绑定状态 启用 停用
BindTree();
string strSql="SELECT o.*,(select USER_NAME from sys_user where user_id =o.create_by )as create_Username , "
+"(select USER_NAME from sys_user where user_id =o.update_by ) as update_username FROM tb_organization o where org_id='"+id+"'";
SQLObj sqlobj=new SQLObj();
sqlobj.cmdType=CommandType.Text;
sqlobj.Param=new Dictionary<string,ParamObj>();
sqlobj.sqlString=strSql;
DataSet ds= DBHelper.GetDataSet("查询组织", sqlobj);
//DBHelper.GetTable("查询组织", "tb_organization", "*", "org_id='" + id + "'", "", "");
if (ds ==null || ds.Tables[0].Rows.Count <= 0)
{
MessageBoxEx.Show("查询组织失败！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
DataTable dt = ds.Tables[0];
CommonCtrl.SelectTreeView(tvCompany, dt.Rows[0]["parent_id"].ToString());
lblporg_code.Text = tvCompany.SelectedNode.Name;
lblporg_name.Text = tvCompany.SelectedNode.Text;
lblorg_code.Text = dt.Rows[0]["org_code"].ToString();
lblorg_name.Text = dt.Rows[0]["org_name"].ToString();
lblorg_short_name.Text = dt.Rows[0]["org_short_name"].ToString();
lblremark.Text = dt.Rows[0]["remark"].ToString();
lblcontact_name.Text = dt.Rows[0]["contact_name"].ToString();
lblcontact_telephone.Text = dt.Rows[0]["contact_telephone"].ToString();
lblcreate_Username.Text = dt.Rows[0]["create_Username"].ToString();
lblcreate_time.Text = Common.UtcLongToLocalDateTime(Convert.ToInt64(dt.Rows[0]["create_time"].ToString())).ToString();
lblupdate_username.Text = dt.Rows[0]["update_username"].ToString();
lblupdate_time.Text = Common.UtcLongToLocalDateTime(Convert.ToInt64(dt.Rows[0]["update_time"].ToString())).ToString();
cbostate.SelectedValue = dt.Rows[0]["status"].ToString();
}
private void ImportMData(List<SQLObj> listSql, string strId, string strReservId)
{
#region 维修用料信息
DataTable dmt = DBHelper.GetTable("维修用料数据", "tb_maintain_material_detail", "*", string.Format(" maintain_id ='{0}'", strReservId), "", "");
for (int K = 0; K < dmt.Rows.Count; K++)
{
SQLObj obj = new SQLObj();
obj.cmdType = CommandType.Text;
Dictionary<string, ParamObj> dicParam = new Dictionary<string, ParamObj>();
DataRow mrow = dmt.Rows[K];
dicParam.Add("maintain_id", new ParamObj("maintain_id", strId, SysDbType.VarChar, 40));
dicParam.Add("parts_code", new ParamObj("parts_code", CommonCtrl.IsNullToString(mrow["parts_code"]), SysDbType.VarChar, 40));
dicParam.Add("parts_name", new ParamObj("parts_name", CommonCtrl.IsNullToString(mrow["parts_name"]), SysDbType.VarChar, 40));
dicParam.Add("norms", new ParamObj("norms", CommonCtrl.IsNullToString(mrow["norms"]), SysDbType.VarChar, 40));
dicParam.Add("unit", new ParamObj("unit", CommonCtrl.IsNullToString(mrow["unit"]), SysDbType.VarChar, 20));
dicParam.Add("whether_imported", new ParamObj("whether_imported", CommonCtrl.IsNullToString(mrow["whether_imported"]), SysDbType.VarChar, 1));
dicParam.Add("quantity", new ParamObj("quantity", !string.IsNullOrEmpty(CommonCtrl.IsNullToString(mrow["quantity"])) ? mrow["quantity"] : null, SysDbType.Decimal, 15));
dicParam.Add("unit_price", new ParamObj("unit_price", !string.IsNullOrEmpty(CommonCtrl.IsNullToString(mrow["unit_price"])) ? mrow["unit_price"] : null, SysDbType.Decimal, 15));
dicParam.Add("member_discount", new ParamObj("member_discount", !string.IsNullOrEmpty(CommonCtrl.IsNullToString(mrow["member_discount"])) ? mrow["member_discount"] : null, SysDbType.Decimal, 15));
dicParam.Add("member_price", new ParamObj("member_price", !string.IsNullOrEmpty(CommonCtrl.IsNullToString(mrow["member_price"])) ? mrow["member_price"] : null, SysDbType.Decimal, 15));
dicParam.Add("sum_money", new ParamObj("sum_money", !string.IsNullOrEmpty(CommonCtrl.IsNullToString(mrow["sum_money"])) ? mrow["sum_money"] : null, SysDbType.Decimal, 15));
dicParam.Add("drawn_no", new ParamObj("drawn_no", CommonCtrl.IsNullToString(mrow["drawn_no"]), SysDbType.VarChar, 40));
dicParam.Add("vehicle_brand", new ParamObj("vehicle_brand", CommonCtrl.IsNullToString(mrow["vehicle_brand"]), SysDbType.VarChar, 40));
dicParam.Add("three_warranty", new ParamObj("three_warranty", CommonCtrl.IsNullToString(mrow["three_warranty"]), SysDbType.VarChar, 2));
dicParam.Add("remarks", new ParamObj("remarks", CommonCtrl.IsNullToString(mrow["remarks"]), SysDbType.VarChar, 200));
dicParam.Add("enable_flag", new ParamObj("enable_flag", "1", SysDbType.VarChar, 1));
dicParam.Add("material_id", new ParamObj("material_id", Guid.NewGuid().ToString(), SysDbType.VarChar, 40));
obj.sqlString = @"insert into [tb_maintain_material_detail] (maintain_id,parts_code,parts_name,norms,unit,whether_imported,quantity,unit_price,sum_money
,drawn_no,vehicle_brand,three_warranty,remarks,enable_flag,material_id)
values (@maintain_id,@parts_code,@parts_name,@norms,@unit,@whether_imported,@quantity,@unit_price,@sum_money
,@drawn_no,@vehicle_brand,@three_warranty,@remarks,@enable_flag,@material_id
);";
obj.Param = dicParam;
listSql.Add(obj);
}
#endregion
}
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
}
private void ImportReserData(List<SQLObj> listSql, string strRId)
{
string strWOrderNo = CommonUtility.GetNewNo(SYSModel.DataSources.EnumProjectType.Repair);
strNewMaintainNo = strWOrderNo;
strId = string.Empty; ;
DataTable dt = DBHelper.GetTable("查询预约单", "tb_maintain_reservation", "*", " reserv_id in (" + strRId + ")", "", "");
for (int i = 0; i < dt.Rows.Count; i++)
{
SQLObj obj = new SQLObj();
obj.cmdType = CommandType.Text;
Dictionary<string, ParamObj> dicParam = new Dictionary<string, ParamObj>();
#region 基本信息
DataRow row = dt.Rows[i];
strReservId = CommonCtrl.IsNullToString(row["reserv_id"]);
dicParam.Add("maintain_no", new ParamObj("maintain_no", strWOrderNo, SysDbType.VarChar, 40));//维修单号
dicParam.Add("reception_time", new ParamObj("reception_time", DateTime.UtcNow.Ticks, SysDbType.BigInt));//接待日期
dicParam.Add("vehicle_no", new ParamObj("vehicle_no", CommonCtrl.IsNullToString(row["vehicle_no"]), SysDbType.VarChar, 40));//车牌号
dicParam.Add("vehicle_vin", new ParamObj("vehicle_vin", CommonCtrl.IsNullToString(row["vehicle_vin"]), SysDbType.VarChar, 40));//VIN
dicParam.Add("engine_no", new ParamObj("engine_no", CommonCtrl.IsNullToString(row["engine_type"]), SysDbType.VarChar, 40));//发动机号
dicParam.Add("vehicle_model", new ParamObj("vehicle_model", CommonCtrl.IsNullToString(row["vehicle_model"]), SysDbType.VarChar, 40));//车型
dicParam.Add("vehicle_brand", new ParamObj("vehicle_brand", CommonCtrl.IsNullToString(row["vehicle_brand"]), SysDbType.VarChar, 40));//车辆品牌
dicParam.Add("driver_name", new ParamObj("driver_name", CommonCtrl.IsNullToString(row["driver_name"]), SysDbType.VarChar, 20));//司机
dicParam.Add("driver_mobile", new ParamObj("driver_mobile", CommonCtrl.IsNullToString(row["driver_mobile"]), SysDbType.VarChar, 15));//司机手机
dicParam.Add("vehicle_color", new ParamObj("vehicle_color", CommonCtrl.IsNullToString(row["vehicle_color"]), SysDbType.VarChar, 40));//颜色
dicParam.Add("customer_code", new ParamObj("customer_code", CommonCtrl.IsNullToString(row["customer_code"]), SysDbType.VarChar, 40));//客户编码
dicParam.Add("customer_name", new ParamObj("customer_name", CommonCtrl.IsNullToString(row["customer_name"]), SysDbType.VarChar, 40));//客户名称
dicParam.Add("customer_id", new ParamObj("customer_id", CommonCtrl.IsNullToString(row["customer_id"]), SysDbType.VarChar, 40));//客户关联id
dicParam.Add("linkman", new ParamObj("linkman", CommonCtrl.IsNullToString(row["linkman"]), SysDbType.VarChar, 20));//联系人
dicParam.Add("link_man_mobile", new ParamObj("link_man_mobile", CommonCtrl.IsNullToString(row["link_man_mobile"]), SysDbType.VarChar, 15));//联系人手机
dicParam.Add("maintain_payment", new ParamObj("maintain_payment", CommonCtrl.IsNullToString(row["maintain_payment"]), SysDbType.VarChar, 40));//维修付费方式
dicParam.Add("maintain_type", new ParamObj("maintain_type", CommonCtrl.IsNullToString(row["maintain_type"]), SysDbType.VarChar, 40));//维修类别
dicParam.Add("fault_describe", new ParamObj("fault_describe", CommonCtrl.IsNullToString(row["fault_describe"]), SysDbType.VarChar, 40));//故障描述
dicParam.Add("remark", new ParamObj("remark", CommonCtrl.IsNullToString(row["remark"]), SysDbType.VarChar, 40));//备注
dicParam.Add("info_status", new ParamObj("info_status", CommonCtrl.IsNullToString(row["document_status"]), SysDbType.VarChar, 40));//单据状态415A3ADF-96C5-495C-8C98-478AA489E0A9表示接待单
dicParam.Add("enable_flag", new ParamObj("enable_flag", CommonCtrl.IsNullToString(row["enable_flag"]), SysDbType.VarChar, 1));//信息状态（1|激活；2|作废；0|删除）
strId = Guid.NewGuid().ToString();
dicParam.Add("maintain_id", new ParamObj("maintain_id", strId, SysDbType.VarChar, 40));//新ID
dicParam.Add("create_opid", new ParamObj("create_opid", HXCPcClient.GlobalStaticObj.UserID, SysDbType.VarChar, 40));//创建人id（制单人）
dicParam.Add("create_name", new ParamObj("create_name", HXCPcClient.GlobalStaticObj.UserName, SysDbType.VarChar, 40));//创建人
dicParam.Add("create_time", new ParamObj("create_time", DateTime.UtcNow.Ticks, SysDbType.BigInt));//创建时间
obj.sqlString = @"insert into [tb_maintain_info] (maintain_no,reception_time,vehicle_no,vehicle_vin,engine_no,vehicle_model,vehicle_brand
,driver_name,driver_mobile,vehicle_color,customer_name,customer_id,linkman,link_man_mobile,maintain_payment,maintain_type,fault_describe,remark,info_status
,enable_flag,maintain_id,create_opid,create_name,create_time)
values (@maintain_no,@reception_time,@vehicle_no,@vehicle_vin,@engine_no,@vehicle_model,@vehicle_brand
,@driver_name,@driver_mobile,@vehicle_color,@customer_name,@customer_id,@linkman,@link_man_mobile,@maintain_payment,@maintain_type,@fault_describe,@remark,@info_status
,@enable_flag,@maintain_id,@create_opid,@create_name,@create_time);";
obj.Param = dicParam;
listSql.Add(obj);
#endregion
}
}
/// <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(strReservId))
{
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);
}
}
void UCReceiveView_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("maintain_id", new ParamObj("maintain_id", strReceiveId, 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_info set info_status=@info_status,Verify_advice=@Verify_advice,update_by=@update_by,update_name=@update_name,update_time=@update_time where maintain_id=@maintain_id";
obj.Param = dicParam;
listSql.Add(obj);
UpdateMaintainInfo(listSql, strBeforOrderId, strBeforSource, "0");
if (DBHelper.BatchExeSQLMultiByTrans("更新单据状态为审核", listSql))
{
string strMsg = string.Empty;
if (verify.auditStatus == DataSources.EnumAuditStatus.AUDIT)
{
strMsg = "成功";
}
else
{
strMsg = "不通过";
}
MessageBoxEx.Show("审核" + strMsg + "！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
uc.BindPageData();
deleteMenuByTag(this.Tag.ToString(), uc.Name);
}
}
}
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();
}
}
}
private void tvFunction_NodeMouseClick(object sender, TreeNodeMouseClickEventArgs e)
{
DataSet ds = new DataSet();
DataSet dsByRid = new DataSet();
ds.Clear();
StringBuilder strBD = new StringBuilder();
strBD.Append("with fun as( select * from sys_function where fun_id = '" + e.Node.Name + "' union all select sf.* from fun f inner join sys_function sf on f.fun_id = sf.parent_id ) ");
strBD.Append(" select fun_id,num,fun_name,fun_ename,fun_uri ,fun_img,parent_id,fun_cbs ,fun_level ,fun_idx ,fun_flag ,fun_run ");
strBD.Append(" ,CONVERT(bit,button_browse) button_browse,CONVERT(bit,button_add) button_add ,CONVERT(bit,button_edit)button_edit ");
strBD.Append(" ,CONVERT(bit,button_copy )button_copy ,CONVERT(bit,button_delete)button_delete,CONVERT(bit,button_cancel) button_cancel ");
strBD.Append(" ,CONVERT(bit,button_activate) button_activate,CONVERT(bit,button_status) button_status,CONVERT(bit,button_confirm) button_confirm ");
strBD.Append(" ,CONVERT(bit,button_save) button_save,CONVERT(bit,button_submit) button_submit ,CONVERT(bit,button_verify) button_verify");
strBD.Append(" ,CONVERT(bit,button_revoke) button_revoke,CONVERT(bit,button_sync) button_sync,CONVERT(bit,button_import) button_import");
strBD.Append(" ,CONVERT(bit,button_export) button_export ,CONVERT(bit,button_print) button_print ,CONVERT(bit,button_operation_record)button_operation_record ");
strBD.Append(" ,CONVERT(bit,button_dispatching) button_dispatching ,CONVERT(bit,button_balance) button_balance ");
strBD.Append(" ,enable_flag ,remark ,create_by,create_time,update_by ,update_time,CONVERT(bit, '0') as isall from fun where fun_run='1' and fun_flag='1' and enable_flag='1' ");
SYSModel.SQLObj sqlobj = new SYSModel.SQLObj();
sqlobj.cmdType = CommandType.Text;
sqlobj.Param = new Dictionary <string, SYSModel.ParamObj>();
sqlobj.sqlString = strBD.ToString();
ds = DBHelper.GetDataSet("查询角色权限", sqlobj);
if (wStatus == WindowStatus.Edit)
{
dsByRid.Clear();
string strSql = " with fun as( select * from sys_function where fun_id = '" + e.Node.Name + "' union all "
+ "select sf.* from fun f inner join sys_function sf on f.fun_id = sf.parent_id ) "
+ "select fun.fun_id,fun.num,fun.fun_name,fun.fun_ename,fun.fun_uri ,fun.fun_img,fun.parent_id,fun.fun_cbs ,fun.fun_level ,fun.fun_idx ,fun.fun_flag ,fun.fun_run "
+ " ,CONVERT(bit,rf.button_browse) button_browse,CONVERT(bit,rf.button_add) button_add ,CONVERT(bit,rf.button_edit)button_edit "
+ " ,CONVERT(bit,rf.button_copy )button_copy ,CONVERT(bit,rf.button_delete)button_delete,CONVERT(bit,rf.button_cancel) button_cancel "
+ " ,CONVERT(bit,rf.button_activate) button_activate,CONVERT(bit,rf.button_status) button_status,CONVERT(bit,rf.button_confirm) button_confirm "
+ " ,CONVERT(bit,rf.button_save) button_save,CONVERT(bit,rf.button_submit) button_submit ,CONVERT(bit,rf.button_verify) button_verify"
+ " ,CONVERT(bit,rf.button_revoke) button_revoke,CONVERT(bit,rf.button_sync) button_sync,CONVERT(bit,rf.button_import) button_import"
+ " ,CONVERT(bit,rf.button_export) button_export ,CONVERT(bit,rf.button_print) button_print ,CONVERT(bit,rf.button_operation_record)button_operation_record "
+ " ,CONVERT(bit,rf.button_dispatching) button_dispatching ,CONVERT(bit,rf.button_balance) button_balance "
+ " ,fun.enable_flag ,fun.remark ,fun.create_by,fun.create_time,fun.update_by ,fun.update_time,CONVERT(bit, '0') as isall "
+ " from fun ,tr_role_function rf,sys_role sr where rf.role_id =sr.role_id and rf.fun_id=fun.fun_id and sr.role_id='" + id + "' "
+ " and fun.fun_run='1' and fun.fun_flag='1' and fun.enable_flag='1' ";
SYSModel.SQLObj sobj = new SYSModel.SQLObj();
sobj.cmdType = CommandType.Text;
sobj.Param = new Dictionary <string, SYSModel.ParamObj>();
sobj.sqlString = strSql;
dsByRid = DBHelper.GetDataSet("查询角色权限", sobj);
if (dsByRid != null && dsByRid.Tables[0].Rows.Count > 0 && ds != null && ds.Tables[0].Rows.Count > 0)
{
DataTable dttem = ds.Tables[0].Clone();
ArrayList iList = new ArrayList();
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
foreach (DataRow dtFunRow in dsByRid.Tables[0].Rows)
{
if (ds.Tables[0].Rows[i]["fun_id"].ToString() == dtFunRow["fun_id"].ToString())
{
//row.Delete();
iList.Add(i);
dttem.Rows.Add(ConvertDtRow(dttem, dtFunRow));
}
}
}
if (iList.Count > 0)
{
iList.Sort();
for (int j = iList.Count - 1; j >= 0; j--)
{
ds.Tables[0].Rows.RemoveAt(Convert.ToInt32(iList[j]));
}
}
if (dttem.Rows.Count > 0)
{
foreach (DataRow dr in dttem.Rows)
{
ds.Tables[0].Rows.Add(ConvertDtRow(ds.Tables[0], dr));
}
}
}
}
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
DataTable tem = ds.Tables[0].Clone();
if (dtFun.Rows.Count > 0)
{
// ds.Tables[0].AcceptChanges();
ArrayList iList = new ArrayList();
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
foreach (DataRow dtFunRow in dtFun.Rows)
{
if (ds.Tables[0].Rows[i]["fun_id"].ToString() == dtFunRow["fun_id"].ToString())
{
//row.Delete();
iList.Add(i);
tem.Rows.Add(ConvertDtRow(tem, dtFunRow));
}
}
}
if (iList.Count > 0)
{
for (int j = iList.Count - 1; j >= 0; j--)
{
ds.Tables[0].Rows.RemoveAt(Convert.ToInt32(iList[j]));
}
}
if (tem.Rows.Count > 0)
{
foreach (DataRow dr in tem.Rows)
{
ds.Tables[0].Rows.Add(ConvertDtRow(ds.Tables[0], dr));
}
}
}
}
dgvFunction.DataSource = ds.Tables[0].DefaultView;
}
private void ImportOData(List<SQLObj> listSql, string strId, string strReservId)
{
#region 其他项目收费信息
DataTable dot = DBHelper.GetTable("其他项目收费数据", "tb_maintain_other_toll", "*", string.Format(" maintain_id ='{0}'", strReservId), "", "");
for (int l = 0; l < dot.Rows.Count; l++)
{
SQLObj obj = new SQLObj();
obj.cmdType = CommandType.Text;
Dictionary<string, ParamObj> dicParam = new Dictionary<string, ParamObj>();
DataRow orow = dot.Rows[l];
dicParam.Add("maintain_id", new ParamObj("maintain_id", strId, SysDbType.VarChar, 40));
dicParam.Add("cost_types", new ParamObj("cost_types", CommonCtrl.IsNullToString(orow["cost_types"]), SysDbType.VarChar, 40));
dicParam.Add("sum_money", new ParamObj("sum_money",!string.IsNullOrEmpty(CommonCtrl.IsNullToString(orow["sum_money"]))?CommonCtrl.IsNullToString(orow["sum_money"]):null, SysDbType.Decimal, 18));
dicParam.Add("remarks", new ParamObj("remarks", CommonCtrl.IsNullToString(orow["remarks"]), SysDbType.VarChar, 200));
dicParam.Add("enable_flag", new ParamObj("enable_flag", "1", SysDbType.Char, 10));
dicParam.Add("toll_id", new ParamObj("toll_id", Guid.NewGuid().ToString(), SysDbType.VarChar, 40));
obj.sqlString = @"insert into [tb_maintain_other_toll] (maintain_id,cost_types,sum_money,remarks,enable_flag,toll_id)
values (@maintain_id,@cost_types,@sum_money,@remarks,@enable_flag,@toll_id);";
obj.Param = dicParam;
listSql.Add(obj);
}
#endregion
}
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
}
private void SaveOrderInfo(List<SQLObj> listSql, DataSources.EnumAuditStatus status)
{
try
{
SQLObj obj = new SQLObj();
obj.cmdType = CommandType.Text;
Dictionary<string, ParamObj> dicParam = new Dictionary<string, ParamObj>();
#region 基本信息
dicParam.Add("receipt_time", new ParamObj("receipt_time", Common.LocalDateTimeToUtcLong(dtpMakeOrderTime.Value).ToString(), SysDbType.BigInt));//制单日期
dicParam.Add("remarks", new ParamObj("remarks", txtRemark.Caption.Trim(), SysDbType.VarChar, 200));//备注
#endregion
//经办人id
dicParam.Add("responsible_opid", new ParamObj("responsible_opid", !string.IsNullOrEmpty(CommonCtrl.IsNullToString(cobYHandle.SelectedValue)) ? cobYHandle.SelectedValue.ToString() : null, SysDbType.VarChar, 40));
//经办人
dicParam.Add("responsible_name", new ParamObj("responsible_name", !string.IsNullOrEmpty(CommonCtrl.IsNullToString(cobYHandle.SelectedValue)) ? cobYHandle.SelectedText : null, SysDbType.VarChar, 40));
//部门
dicParam.Add("org_name", new ParamObj("org_name", !string.IsNullOrEmpty(CommonCtrl.IsNullToString(cboOrgId.SelectedValue)) ? cboOrgId.SelectedValue : null, SysDbType.VarChar, 40));
dicParam.Add("enable_flag", new ParamObj("enable_flag", Convert.ToInt32(DataSources.EnumEnableFlag.USING).ToString(), SysDbType.VarChar, 1));//信息状态（1|激活；2|作废；0|删除）
//单据类型
if (status == DataSources.EnumAuditStatus.SUBMIT)//提交操作时生成单号
{
dicParam.Add("receipts_no", new ParamObj("receipts_no", labPalNoS.Text.Trim(), SysDbType.VarChar, 40));//返厂单号
//单据状态
dicParam.Add("info_status", new ParamObj("info_status", Convert.ToInt32(status).ToString(), SysDbType.VarChar, 40));
}
else
{
if (!string.IsNullOrEmpty(strStatus) && strStatus != Convert.ToInt32(DataSources.EnumAuditStatus.DRAFT).ToString())
{
dicParam.Add("receipts_no", new ParamObj("receipts_no", labPalNoS.Text.Trim(), SysDbType.VarChar, 40));//返厂单号
//单据状态
dicParam.Add("info_status", new ParamObj("info_status", Convert.ToInt32(strStatus).ToString(), SysDbType.VarChar, 40));
}
else
{
dicParam.Add("receipts_no", new ParamObj("receipts_no", null, SysDbType.VarChar, 40));//返厂单号
//单据状态
dicParam.Add("info_status", new ParamObj("info_status", Convert.ToInt32(status).ToString(), SysDbType.VarChar, 40));
}
}
dicParam.Add("return_id", new ParamObj("return_id", strId, SysDbType.VarChar, 40));//Id
if (wStatus == WindowStatus.Add)
{
strId = Guid.NewGuid().ToString();
dicParam.Add("create_by", new ParamObj("create_by", HXCPcClient.GlobalStaticObj.UserID, SysDbType.VarChar, 40));//创建人id（制单人）
dicParam.Add("create_name", new ParamObj("create_name", HXCPcClient.GlobalStaticObj.UserName, SysDbType.VarChar, 40));//创建人
dicParam.Add("create_time", new ParamObj("create_time", Common.LocalDateTimeToUtcLong(HXCPcClient.GlobalStaticObj.CurrentDateTime).ToString(), SysDbType.BigInt));
obj.sqlString = @"update tb_maintain_oldpart_recycle set receipt_time=@receipt_time,remarks=@remarks,responsible_opid=@responsible_opid,responsible_name=@responsible_name
,org_name=@org_name,enable_flag=@enable_flag,info_status=@info_status,receipts_no=@receipts_no,create_by=@create_by,create_name=@create_name,create_time=@create_time
where return_id=@return_id ";
}
else if (wStatus == WindowStatus.Edit)
{
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 receipt_time=@receipt_time,remarks=@remarks,responsible_opid=@responsible_opid,responsible_name=@responsible_name
,org_name=@org_name,enable_flag=@enable_flag,info_status=@info_status,receipts_no=@receipts_no,update_by=@update_by,update_name=@update_name,update_time=@update_time
where return_id=@return_id";
}
obj.Param = dicParam;
listSql.Add(obj);
}
catch (Exception ex)
{
HXCPcClient.GlobalStaticObj.GlobalLogService.WriteLog(ex);
}
}
/// <summary>
/// 提交功能,提交时添加单号
/// </summary>
/// <param name="strMessage">提示信息</param>
/// <param name="status">单据状态</param>
private void SubmitAndVerify(string strMessage, DataSources.EnumAuditStatus status)
{
List<SQLObj> listSql = new List<SQLObj>();
string strReceId = string.Empty;//单据Id值
string strOrderNo = string.Empty;//单据编号
foreach (DataGridViewRow dr in dgvRData.Rows)
{
object isCheck = dr.Cells["colCheck"].EditedFormattedValue;
if (isCheck != null && (bool)isCheck)
{
strReceId += dr.Cells["return_id"].Value.ToString() + ",";
strOrderNo = dr.Cells["receipts_no"].Value.ToString();
SQLObj obj = new SQLObj();
obj.cmdType = CommandType.Text;
Dictionary<string, ParamObj> dicParam = new Dictionary<string, ParamObj>();
dicParam.Add("receipts_no", new ParamObj("receipts_no",!string.IsNullOrEmpty(strOrderNo)?strOrderNo: CommonUtility.GetNewNo(SYSModel.DataSources.EnumProjectType.OldPartsPalautus), SysDbType.VarChar, 40));//单据编号
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", status, 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_oldpart_recycle set info_status=@info_status,receipts_no=@receipts_no,update_by=@update_by,update_name=@update_name,update_time=@update_time where return_id=@return_id";
obj.Param = dicParam;
listSql.Add(obj);
}
}
if (string.IsNullOrEmpty(strReceId))
{
MessageBoxEx.Show("请选择需要" + strMessage + "的记录！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
if (DBHelper.BatchExeSQLMultiByTrans("更新单据状态为提交", listSql))
{
MessageBoxEx.Show("" + strMessage + "成功！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
BindPageData();
}
}
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);
}
}
void UCReceiveView_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.Repair);
}
dicParam.Add("maintain_no", new ParamObj("maintain_no", labMaintain_noS.Text, SysDbType.VarChar, 40));//单据编号
dicParam.Add("maintain_id", new ParamObj("maintain_id", strReceiveId, SysDbType.VarChar, 40));//单据ID
dicParam.Add("info_status", new ParamObj("info_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_info set info_status=@info_status,maintain_no=@maintain_no,update_by=@update_by,update_name=@update_name,update_time=@update_time where maintain_id=@maintain_id";
obj.Param = dicParam;
listSql.Add(obj);
UpdateMaintainInfo(listSql, strBeforOrderId, strBeforSource, "0");
if (DBHelper.BatchExeSQLMultiByTrans("更新单据状态为提交", listSql))
{
MessageBoxEx.Show("提交成功！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
uc.BindPageData();
deleteMenuByTag(this.Tag.ToString(), uc.Name);
}
}
/// <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>
/// 添加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;
}
/// <summary>
/// 导入后更新预约单-在预约单中添加维修单号
/// </summary>
/// <param name="strReservId">预约单Id</param>
/// <param name="strMaintainNo">维修单号</param>
private void UpdateMaintainNo(List<SQLObj> listSql, string strReservId, string strMaintainNo)
{
SQLObj obj = new SQLObj();
obj.cmdType = CommandType.Text;
Dictionary<string, ParamObj> dicParam = new Dictionary<string, ParamObj>();
dicParam.Add("reserv_id", new ParamObj("reserv_id", strReservId, SysDbType.VarChar, 40));
dicParam.Add("maintain_no", new ParamObj("maintain_no", strMaintainNo, SysDbType.VarChar, 40));
obj.sqlString = "update tb_maintain_reservation set maintain_no=@maintain_no where reserv_id=@reserv_id";
obj.Param = dicParam;
listSql.Add(obj);
}