//验证VIN,CLXZ,是否为空GGPC private string VerifyData(string selectedParamEntityIds) { string msg = string.Empty; StringBuilder sqlStr = new StringBuilder(); sqlStr.AppendFormat(" SELECT *"); sqlStr.AppendFormat(" FROM INFOMATION_ENTITIES "); sqlStr.AppendFormat(" WHERE JZNF = '{0}' ", Settings.Default.ClearYear); if (!string.IsNullOrEmpty(selectedParamEntityIds)) { sqlStr.AppendFormat(" AND VIN in ({0}) ", selectedParamEntityIds); } sqlStr.Append(" order by VIN desc "); DataSet ds = AccessHelper.ExecuteDataSet(AccessHelper.conn, sqlStr.ToString(), null); DataTable dt = ds.Tables[0]; if (dt != null && ds.Tables[0].Rows.Count > 0) { Dictionary <string, string> mapData = new Dictionary <string, string>(); string vin = ""; foreach (DataRow dr in ds.Tables[0].Rows) { vin = dr["VIN"].ToString(); mapData.Clear(); for (int i = 0; i < dr.ItemArray.Count(); i++) { mapData.Add(dt.Columns[i].ColumnName, dr.ItemArray[i].ToString()); } string msgdata = ValidateParam.CheckParameter(mapData); if (msgdata != string.Empty) { msg += String.Format("vin:{0} 数据错误:{1}{2}", vin, Environment.NewLine, msgdata); } } /* * string vin = string.Empty; * var Values = dt.AsEnumerable().Where(d => string.IsNullOrEmpty(d.Field<string>("CLXZ")) || string.IsNullOrEmpty(d.Field<string>("CLXZ"))).Select(d => d.Field<string>("VIN")).ToArray(); * vin = string.Join(",", Values); * if (!string.IsNullOrEmpty(vin)) * { * msg = String.Format("VIN为{0}中的车辆性质或公告批次不能为空", vin); * } * else * { * msg = string.Empty; * }*/ } else { msg = "不存在导出数据"; } return(msg); }
private string VerifyData() { string msg = string.Empty; if (this.txt_NewName.Text.Trim() == this.txt_MainName.Text.Trim()) { msg += "负责人与联系人名字不可相同" + Environment.NewLine; } if (this.txt_NewPhone.Text.Trim() == this.txt_MainPhone.Text.Trim()) { msg += "负责人与联系人手机不可相同" + Environment.NewLine; } if (this.txt_NewMail.Text.Trim() == this.txt_MainMail.Text.Trim()) { msg += "负责人与联系人邮箱不可相同" + Environment.NewLine; } var VerifyDataDic = new Dictionary <string, string>(); VerifyDataDic.Add("NewName", this.txt_NewName.Text.Trim()); VerifyDataDic.Add("NewDepartment", this.txt_NewDepartment.Text.Trim()); VerifyDataDic.Add("NewPost", this.txt_NewPost.Text.Trim()); VerifyDataDic.Add("NewMobile1", this.txt_NewMobile1.Text.Trim()); VerifyDataDic.Add("NewMobile2", this.txt_NewMobile2.Text.Trim()); VerifyDataDic.Add("NewPhone", this.txt_NewPhone.Text.Trim()); VerifyDataDic.Add("NewMail", this.txt_NewMail.Text.Trim()); VerifyDataDic.Add("MainName", this.txt_MainName.Text.Trim()); VerifyDataDic.Add("MainDepartment", this.txt_MainDepartment.Text.Trim()); VerifyDataDic.Add("MainPost", this.txt_MainPost.Text.Trim()); VerifyDataDic.Add("MainMobile1", this.txt_MainMobile1.Text.Trim()); VerifyDataDic.Add("MainMobile2", this.txt_MainMobile2.Text.Trim()); VerifyDataDic.Add("MainPhone", this.txt_MainPhone.Text.Trim()); VerifyDataDic.Add("MainMail", this.txt_MainMail.Text.Trim()); msg += ValidateParam.CheckQYInfomation(VerifyDataDic); return(msg); }