//验证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);
}
