public DataRow viewApplyDetail(string id)
{
CommonClass cc = new CommonClass();
string cmdstr = "select * from ApplyList where id="+id;
DataTable dt = cc.reDt(cmdstr);
return dt.Rows[0];
}
public bool checkTime(string address,string date,string time )
{
CommonClass cc = new CommonClass();
string cmdstr = "select count(*) from ApplyList where status='待审核' or status='审核通过' and applyAddress='" + address +
"' and applyDate = '"+date+"' and applyTime = '"+time+"'";
DataTable dt = cc.reDt(cmdstr);
if (dt.Rows[0][0].ToString() == "0")
return false;
else
return true;
}
/// <summary>
///企业提交宣讲会时间地点申请的函数
/// </summary>
public int submitMessage(string companyName,string companyCode,string companyAddress,string companyContacts,
string companyDeparture,string companyEmail,string companyPhone,string companyMoble,string companyTax,
string agentContacts,string agentName,string agentEmail,string agentPhone,string agentMobile,string applyAddress,
string applyDate,string applyTime,string applier)
{
CommonClass cc = new CommonClass();
string cmdstr =
"insert into ApplyList values('"+companyName+"','"+companyCode+"','"+companyAddress+
"','" + companyContacts + "','" + companyDeparture + "','" + companyEmail + "','"+companyPhone+
"','"+companyMoble+"','"+companyTax+"','"+agentContacts+"','"+agentName+
"','"+agentEmail+"','"+agentPhone+"','"+agentMobile+"','"+applyAddress+
"','"+applyDate+"','"+applyTime+"',NULL,NULL,NULL,NULL,NULL,NULL,'"+applier+"','"+DateTime.Now.ToString()+"','待审核')";
return cc.sqlEx(cmdstr);
}
private void LeaveEvent(object sender, EventArgs e)
{
CommonClass.LeaveEvents(sender, e);
}
private void FormBegin_Load(object sender, EventArgs e)
{
CommonClass common = new CommonClass();
this.textBox1.Text = common.GetConfigValue("SAVEDIR");
}
protected void Page_UnLoad(object sender, EventArgs e)
{
objCommonClass = null;
objwscCustomerComplaint = null;
}
private void txt_KeyPress(object sender, KeyPressEventArgs e)
{
CommonClass.KeyPressEvents(sender, e);
}
protected void Page_UnLoad(object sender, EventArgs e)
{
objCommonClass = null;
objBranchMaster = null;
}
//保存
protected void BtnSave_Click(object sender, EventArgs e)
{
TB_System_Dictionary model = new TB_System_Dictionary();
if (ViewState["id"] != null)
{
model = SystemService.DictionaryService.Get(ViewState["id"]);
if (model.Code != TbCode.Text.TrimEnd())
{
List <Expression> express = new List <Expression>();
express.Add(new Expression("Code", "=", TbCode.Text.TrimEnd()));
express.Add(new Expression("TypeCode", "=", model.TypeCode));
var list = SystemService.DictionaryService.Search(express);
if (list.Count > 0)
{
MessageDiv.InnerHtml = CommonClass.Alert("当前标识已存在，请重新输入");
return;
}
}
}
else
{
List <Expression> express = new List <Expression>();
express.Add(new Expression("Code", "=", TbCode.Text.TrimEnd()));
express.Add(new Expression("TypeCode", "=", DDLModel.SelectedValue));
var list = SystemService.DictionaryService.Search(express);
if (list.Count > 0)
{
MessageDiv.InnerHtml = CommonClass.Alert("当前标识已存在，请重新输入");
return;
}
}
model.TypeCode = DDLModel.SelectedValue;
model.Name = TbName.Text.Trim();
model.Code = TbCode.Text;
model.Remark = TbRemark.Text;
model.OrderBy = TbOrderBy.Text.ToInt();
model.Creater = AdminUserName;
model.AddDate = DateTime.Now;
ISystem_Dictionary Dictionary = SystemService.DictionaryService;
if (ViewState["id"] == null)
{
if (Dictionary.Insert(model) == 1)
{
CachesHelper.RemoveCache(DataToCacheHelper.CacheNames.AllDictionaries.ToStr());
MessageDiv.InnerHtml = CommonClass.Reload("数据添加成功");
}
else
{
MessageDiv.InnerHtml = CommonClass.Alert("数据添加失败");
}
}
else
{
if (Dictionary.Update(model) == 1)
{
CachesHelper.RemoveCache(DataToCacheHelper.CacheNames.AllDictionaries.ToStr());
MessageDiv.InnerHtml = CommonClass.Reload("数据修改成功");
}
else
{
MessageDiv.InnerHtml = CommonClass.Alert("数据修改失败");
}
}
}
protected void Page_UnLoad(object sender, EventArgs e)
{
objCommonClass = null;
objWSCEscalationMatrix = null;
}
protected void imgBtnAdd_Click(object sender, EventArgs e)
{
try
{
string strMessage = "";
string strTerDesc = "";
int routingSno = 0;
int intCounter = 0;
objRoutingMaster.CreatedDate = DateTime.Now.ToString();
if (lstbxProductDiv.Items.Count == 0)
{
#region for single product division
foreach (GridViewRow grv in gvTerritory.Rows)
{
if (((CheckBox)grv.FindControl("chkChild")).Checked == true)
{
intCounter = intCounter + 1;
//Assigning values to properties
objRoutingMaster.RoutingSno = 0;
objRoutingMaster.UnitSNo = int.Parse(ddlProductDivision.SelectedValue.ToString());
objRoutingMaster.ProductLineSno = int.Parse(ddlProductLine.SelectedValue.ToString());
objRoutingMaster.SCSNo = int.Parse(ddlSC.SelectedValue.ToString());
objRoutingMaster.StateSNo = int.Parse(ddlState.SelectedValue.ToString());
objRoutingMaster.CitySNo = int.Parse(ddlCity.SelectedValue.ToString());
strTerDesc = ((Label)grv.FindControl("lblTerritory_Desc")).Text;
HiddenField hndTerritorySno = (HiddenField)grv.FindControl("hdnTerritorySno");
objRoutingMaster.TerritorySNo = int.Parse(hndTerritorySno.Value.ToString());
// Comment by Mukesh Kumar as on 25.May.15
//Label lblPPreference = (Label)grv.FindControl("lblPreference");
//objRoutingMaster.Preference = lblPPreference.Text.Trim();
//Label lblSpecialRemarks = (Label)grv.FindControl("lblSpecialRemarks");
//objRoutingMaster.SpecialRemarks = lblSpecialRemarks.Text.Trim();
objRoutingMaster.Preference = "0"; // Added by Mukesh Kumar as on 25.May.15
objRoutingMaster.SpecialRemarks = ""; // Added by Mukesh Kumar as on 25.May.15
objRoutingMaster.EmpCode = Membership.GetUser().UserName.ToString();
objRoutingMaster.ActiveFlag = rdoStatus.SelectedValue.ToString();
//Calling SaveData to save Routing details information
//and pass SP Type "INSERT_ROUTING" it "return"
//if record is not already exist otherwise exists
string strMsg = objRoutingMaster.SaveData("INSERT_ROUTING");
routingSno = objRoutingMaster.ReturnRoutingSno;
if (objRoutingMaster.ReturnValue == -1)
{
lblMessage.Text = CommonClass.getErrorWarrning(enuErrorWarrning.ErrorInStoreProc, enuMessageType.Error, false, "");
}
else
{
if (strMsg == "Exists")
{
strMessage = strMessage + strTerDesc + ",";
}
else
{
lblMessage.Text = CommonClass.getErrorWarrning(enuErrorWarrning.AddRecord, enuMessageType.UserMessage, false, "");
}
}
}
}
//if (routingSno > 0)
// sendDBMail(routingSno); Commented on 9.9.14 after CG Approval
#endregion for single product division
}
else
{
#region for multiple product division
for (int i = 0; i < lstbxProductDiv.Items.Count; i++)
{
foreach (GridViewRow grv in gvTerritory.Rows)
{
if (((CheckBox)grv.FindControl("chkChild")).Checked == true)
{
intCounter = intCounter + 1;
//Assigning values to properties
objRoutingMaster.RoutingSno = 0;
objRoutingMaster.UnitSNo = int.Parse(lstbxProductDiv.Items[i].Value.ToString());
objRoutingMaster.ProductLineSno = int.Parse(ddlProductLine.SelectedValue.ToString());
objRoutingMaster.SCSNo = int.Parse(ddlSC.SelectedValue.ToString());
objRoutingMaster.StateSNo = int.Parse(ddlState.SelectedValue.ToString());
objRoutingMaster.CitySNo = int.Parse(ddlCity.SelectedValue.ToString());
strTerDesc = ((Label)grv.FindControl("lblTerritory_Desc")).Text;
HiddenField hndTerritorySno = (HiddenField)grv.FindControl("hdnTerritorySno");
objRoutingMaster.TerritorySNo = int.Parse(hndTerritorySno.Value.ToString());
// Comment by Mukesh Kumar as on 25.May.15
//Label lblPPreference = (Label)grv.FindControl("lblPreference");
//objRoutingMaster.Preference = lblPPreference.Text.Trim();
//Label lblSpecialRemarks = (Label)grv.FindControl("lblSpecialRemarks");
//objRoutingMaster.SpecialRemarks = lblSpecialRemarks.Text.Trim();
objRoutingMaster.Preference = "0"; // Added by Mukesh Kumar as on 25.May.15
objRoutingMaster.SpecialRemarks = ""; // Added by Mukesh Kumar as on 25.May.15
objRoutingMaster.EmpCode = Membership.GetUser().UserName.ToString();
objRoutingMaster.ActiveFlag = rdoStatus.SelectedValue.ToString();
//Calling SaveData to save Routing details information
//and pass SP Type "INSERT_ROUTING" it "return"
//if record is not already exist otherwise exists
string strMsg = objRoutingMaster.SaveData("INSERT_ROUTING");
routingSno = objRoutingMaster.ReturnRoutingSno;
if (objRoutingMaster.ReturnValue == -1)
{
lblMessage.Text = CommonClass.getErrorWarrning(enuErrorWarrning.ErrorInStoreProc, enuMessageType.Error, false, "");
}
else
{
if (strMsg == "Exists")
{
strMessage = strMessage + strTerDesc + ",";
}
else
{
lblMessage.Text = CommonClass.getErrorWarrning(enuErrorWarrning.AddRecord, enuMessageType.UserMessage, false, "");
}
}
}
}
//if (routingSno > 0)
// sendDBMail(routingSno); Commented on 9.9.14 after CG Approval
}
#endregion for multiple product division
}
if (strMessage != "")
{
strMessage = strMessage.TrimEnd(',');
lblMessage.Text = CommonClass.getErrorWarrning(enuErrorWarrning.DulplicateRecord, enuMessageType.UserMessage, true, " Following territory already assign to " + ddlSC.SelectedItem.Text + " (" + strMessage + " )");
}
if (intCounter == 0)
{
lblMessage.Text = "Please select at-least one row for rout mapping.";
}
}
catch (Exception ex)
{
CommonClass.WriteErrorErrFile(Request.RawUrl.ToString(), ex.StackTrace.ToString() + "-->" + ex.Message.ToString());
}
bindGrid(1, true, "SC_Name");
ClearControls();
}
private void treeList1_MouseDoubleClick(object sender, MouseEventArgs e)
{
try
{
if (this.checkBoxCheckMain.Checked)
{
TreeListNode node = this.treeList1.FocusedNode;
if (!node.HasChildren && node["ERROR"].ToString() != "0" && node["ISCHECK"].ToString() == "已检查")
{
string NAME = node["NAME"].ToString();
string CHECKTYPE = node["CHECKTYPE"].ToString();
string FIELD = node["FIELD"].ToString();
string TABLENAME = node["TABLENAME"].ToString();
string SUPTABLE = node["SUPTABLE"].ToString();
string SELECT = node["SELECT"].ToString();
string WHERESTRING = node["WHERESTRING"].ToString();
string RESULT = node["RESULT"].ToString();
string DOMAINTYPE = node["DOMAINTYPE"].ToString();
string SHOWFIELD = node["SHOWFIELD"].ToString();
DataTable dt = new DataTable();
CommonClass conClass = new CommonClass();
ICursor pFeatureCuror = null;
IFeatureLayer pFLayer = conClass.GetLayerByName(TABLENAME);
IFeatureClass pFeatureClass = pFLayer.FeatureClass;
ITable pTable = pFeatureClass as ITable;
ConnectDB db = new ConnectDB();
if (CHECKTYPE == "空值检查")
{
IQueryFilter pQuery = new QueryFilterClass();
pQuery.WhereClause = FIELD + " IS NULL OR format(" + FIELD + ") = '' ";
pFeatureCuror = pTable.Search(pQuery, false);
}
else if (CHECKTYPE == "逻辑关系检查")
{
IQueryFilter pQuery = new QueryFilterClass();
pQuery.WhereClause = " (" + WHERESTRING + ") and (" + RESULT + ")";
pFeatureCuror = pTable.Search(pQuery, false);
}
else if (CHECKTYPE == "唯一值检查")
{
IQueryFilter pQuery = new QueryFilterClass();
pQuery.WhereClause = FIELD + " in ( select " + FIELD + " as wyz from " + TABLENAME + " group by " + FIELD + " having count(" + FIELD + ")>1)";
pFeatureCuror = pTable.Search(pQuery, false);
}
else if (CHECKTYPE == "项目名称检查")
{
string[] arrStr = FIELD.Split('#');
string fieldStr = arrStr[0];
string taskfieldStr = "CONCAT(" + arrStr[1].Replace("&", ",") + ")";
CommonClass common = new CommonClass();
string gldwstr = common.GetConfigValue("GLDW");
DataTable xmmcArr = db.GetDataBySql("SELECT " + taskfieldStr + " AS XMMCARR FROM GISDATA_TASK WHERE YZLGLDW ='" + gldwstr + "'");
string[] idInts = xmmcArr.AsEnumerable().Select(d => d.Field <string>("XMMCARR")).ToArray();
string codesString = String.Join("','", idInts);
IQueryFilter pQuery = new QueryFilterClass();
pQuery.WhereClause = fieldStr + " not in ('" + codesString + "')";
pFeatureCuror = pTable.Search(pQuery, false);
}
else if (CHECKTYPE == "值域检查")
{
if (DOMAINTYPE == "own")
{
DataTable dt1 = db.GetDataBySql("SELECT CODE_PK,CODE_WHERE FROM GISDATA_MATEDATA WHERE REG_NAME = '" + TABLENAME + "' AND FIELD_NAME = '" + FIELD + "'");
string CODETABLENAME = dt1.Rows[0]["CODE_PK"].ToString();
string CODEWHERESTRING = dt1.Rows[0]["CODE_WHERE"].ToString();
DataTable codeArr = null;
if (CODETABLENAME == "GISDATA_ZQSJZD")
{
CommonClass common = new CommonClass();
string gldwstr = common.GetConfigValue("GLDW");
codeArr = db.GetDataBySql("SELECT C_CODE FROM " + CODETABLENAME + " WHERE " + CODEWHERESTRING + " AND LEFT(C_CODE,6)='" + gldwstr + "'");
}
else
{
codeArr = db.GetDataBySql("SELECT C_CODE FROM " + CODETABLENAME + " WHERE " + CODEWHERESTRING);
}
string[] idInts = codeArr.AsEnumerable().Select(d => d.Field <string>("C_CODE")).ToArray();
string codesString = String.Join("','", idInts);
IQueryFilter pQuery = new QueryFilterClass();
//pQuery.WhereClause = FIELD + " not in (SELECT C_CODE FROM " + CODETABLENAME + " WHERE " + CODEWHERESTRING + ")";
pQuery.WhereClause = FIELD + " IS NOT NULL AND " + FIELD + " <> '' AND " + FIELD + " not in ('" + codesString + "')";
pFeatureCuror = pTable.Search(pQuery, false);
}
else if (DOMAINTYPE == "custom")
{
string CUSTOMVALUE = node["CUSTOMVALUE"].ToString();
IQueryFilter pQuery = new QueryFilterClass();
pQuery.WhereClause = FIELD + " not in (" + CUSTOMVALUE + ") AND " + FIELD + " IS NOT NULL AND " + FIELD + " <> ''";
pFeatureCuror = pTable.Search(pQuery, false);
}
}
if (pFeatureClass == null)
{
return;
}
DataColumn dc = null;
for (int i = 0; i < pFeatureClass.Fields.FieldCount; i++)
{
IField field = pFeatureClass.Fields.get_Field(i);
dc = new DataColumn(field.Name);
dc.Caption = field.AliasName;
dt.Columns.Add(dc);
if (SHOWFIELD.Contains(field.Name))
{
dc.SetOrdinal(0);
}
}
ITable iTable = pFeatureClass as ITable;
IRow pFeature = pFeatureCuror.NextRow();
DataRow dr = null;
while (pFeature != null)
{
dr = dt.NewRow();
int colIndex = 0;
foreach (DataColumn itemColumns in dt.Columns)
{
int index = pFeatureClass.FindField(itemColumns.ColumnName);
if (pFeatureClass.FindField(pFeatureClass.ShapeFieldName) == index)
{
dr[colIndex] = pFeatureClass.ShapeType.ToString();
}
else
{
dr[colIndex] = pFeature.get_Value(index).ToString();
}
colIndex++;
}
dt.Rows.Add(dr);
pFeature = pFeatureCuror.NextRow();
}
GridView gridView = this.gridControlError.DefaultView as GridView;
gridView.Columns.Clear();
this.gridControlError.DataSource = dt;
gridView.OptionsBehavior.Editable = false;
gridView.OptionsSelection.MultiSelect = true;
gridView.ScrollStyle = ScrollStyleFlags.LiveHorzScroll | ScrollStyleFlags.LiveVertScroll;
gridView.HorzScrollVisibility = DevExpress.XtraGrid.Views.Base.ScrollVisibility.Always;
gridView.OptionsView.ColumnAutoWidth = false;
gridView.ViewCaption = "属性检查";
gridView.NewItemRowText = TABLENAME;
this.gridControlError.RefreshDataSource();
Marshal.ReleaseComObject(pFeatureCuror);
Marshal.ReleaseComObject(pFLayer);
}
}
}
catch (Exception ex)
{
LogHelper.WriteLog(typeof(FormAttrDia), ex);
}
}
protected void Page_UnLoad(object sender, EventArgs e)
{
objCommonClass = null;
objCapacitor = null;
}
public void loopCheck(TreeListNodes selectNode, XmlElement Attrs, XmlDocument doc)
{
foreach (TreeListNode node in selectNode)
{
//this.progressBar.Value = Convert.ToInt32((node.Id+1)/this.treeList1.AllNodesCount*100);
DataRowView nodeData = this.treeList1.GetDataRecordByNode(node) as DataRowView;
node.Expanded = true;
nodeData["ERROR"] = "";
nodeData["ISCHECK"] = "";
if (node.Checked || node.CheckState == System.Windows.Forms.CheckState.Indeterminate)
{
if (!node.HasChildren)
{
this.treeList1.FocusedNode = node;
string NAME = nodeData["NAME"].ToString();
Console.WriteLine(NAME);
string CHECKTYPE = nodeData["CHECKTYPE"].ToString();
string FIELD = nodeData["FIELD"].ToString();
string TABLENAME = nodeData["TABLENAME"].ToString();
string SUPTABLE = nodeData["SUPTABLE"].ToString();
string SELECT = nodeData["SELECT"].ToString();
string WHERESTRING = nodeData["WHERESTRING"].ToString();
string RESULT = nodeData["RESULT"].ToString();
string DOMAINTYPE = nodeData["DOMAINTYPE"].ToString();
ConnectDB db = new ConnectDB();
if (CHECKTYPE == "空值检查")
{
try{
CommonClass conClass = new CommonClass();
IFeatureWorkspace ifw = conClass.GetFeatureWorkspaceByName(TABLENAME);
IQueryDef pQueryDef = ifw.CreateQueryDef();
pQueryDef.Tables = TABLENAME;
pQueryDef.SubFields = "count(*) as errorCount";
pQueryDef.WhereClause = FIELD + " IS NULL OR format(" + FIELD + ") = '' ";
ICursor pCur = pQueryDef.Evaluate();
IRow pRow = pCur.NextRow();
int iInx = pCur.Fields.FindField("errorCount");
string count = pRow.get_Value(iInx).ToString();
if (int.Parse(count) > 0)
{
List <string> listItem = new List <string>();
listItem.Add(CHECKTYPE);
listItem.Add(NAME);
listItem.Add(count);
listItem.Add(FIELD + " IS NULL OR format(" + FIELD + ") = '' ");
this.listError.Add(listItem);
}
nodeData["ERROR"] = count;
nodeData["ISCHECK"] = "已检查";
Marshal.ReleaseComObject(pCur);
}
catch (Exception e)
{
LogHelper.WriteLog(typeof(FormAttrDia), e);
LogHelper.WriteLog(typeof(FormAttrDia), FIELD + " IS NULL OR format(" + FIELD + ") = '' ");
}
}
else if (CHECKTYPE == "逻辑关系检查")
{
if (WHERESTRING == "" || RESULT == "")
{
nodeData["ERROR"] = "";
nodeData["ISCHECK"] = "未检查";
}
else
{
try
{
CommonClass conClass = new CommonClass();
IFeatureWorkspace ifw = conClass.GetFeatureWorkspaceByName(TABLENAME);
IQueryDef pQueryDef = ifw.CreateQueryDef();
pQueryDef.Tables = TABLENAME;
pQueryDef.SubFields = "count(*) as errorCount";
pQueryDef.WhereClause = " (" + WHERESTRING + ") and (" + RESULT + ")";
ICursor pCur = pQueryDef.Evaluate();
IRow pRow = pCur.NextRow();
int iInx = pCur.Fields.FindField("errorCount");
string count = pRow.get_Value(iInx).ToString();
if (int.Parse(count) > 0)
{
List <string> listItem = new List <string>();
listItem.Add(CHECKTYPE);
listItem.Add(NAME);
listItem.Add(count);
listItem.Add(" (" + WHERESTRING + ") and (" + RESULT + ")");
this.listError.Add(listItem);
}
nodeData["ERROR"] = count;
nodeData["ISCHECK"] = "已检查";
Marshal.ReleaseComObject(pCur);
}catch (Exception e)
{
LogHelper.WriteLog(typeof(FormAttrDia), e);
LogHelper.WriteLog(typeof(FormAttrDia), " (" + WHERESTRING + ") and (" + RESULT + ")");
}
}
}
else if (CHECKTYPE == "唯一值检查")
{
try{
CommonClass conClass = new CommonClass();
IFeatureWorkspace ifw = conClass.GetFeatureWorkspaceByName(TABLENAME);
IQueryDef pQueryDef = ifw.CreateQueryDef();
pQueryDef.Tables = TABLENAME;
pQueryDef.SubFields = "count(*) as errorCount";
pQueryDef.WhereClause = FIELD + " in ( select " + FIELD + " as wyz from " + TABLENAME + " group by " + FIELD + " having count(" + FIELD + ")>1)";
ICursor pCur = pQueryDef.Evaluate();
IRow pRow = pCur.NextRow();
int iInx = pCur.Fields.FindField("errorCount");
string count = pRow.get_Value(iInx).ToString();
if (int.Parse(count) > 0)
{
List <string> listItem = new List <string>();
listItem.Add(CHECKTYPE);
listItem.Add(NAME);
listItem.Add(count);
listItem.Add(FIELD + " in ( select " + FIELD + " as wyz from " + TABLENAME + " group by " + FIELD + " having count(" + FIELD + ")>1)");
this.listError.Add(listItem);
}
nodeData["ERROR"] = count;
nodeData["ISCHECK"] = "已检查";
Marshal.ReleaseComObject(pCur);
}
catch (Exception e)
{
LogHelper.WriteLog(typeof(FormAttrDia), e);
LogHelper.WriteLog(typeof(FormAttrDia), FIELD + " in ( select " + FIELD + " as wyz from " + TABLENAME + " group by " + FIELD + " having count(" + FIELD + ")>1)");
}
}
else if (CHECKTYPE == "值域检查")
{
try
{
if (DOMAINTYPE == "own")
{
DataTable dt = db.GetDataBySql("SELECT CODE_PK,CODE_WHERE FROM GISDATA_MATEDATA WHERE REG_NAME = '" + TABLENAME + "' AND FIELD_NAME = '" + FIELD + "'");
string CODETABLENAME = dt.Rows[0]["CODE_PK"].ToString();
string CODEWHERESTRING = dt.Rows[0]["CODE_WHERE"].ToString();
if (CODETABLENAME != "" && CODEWHERESTRING != "")
{
DataTable codeArr = null;
if (CODETABLENAME == "GISDATA_ZQSJZD")
{
CommonClass common = new CommonClass();
string gldwstr = common.GetConfigValue("GLDW");
codeArr = db.GetDataBySql("SELECT C_CODE FROM " + CODETABLENAME + " WHERE " + CODEWHERESTRING + " AND LEFT(C_CODE,6)='" + gldwstr + "'");
}
else
{
codeArr = db.GetDataBySql("SELECT C_CODE FROM " + CODETABLENAME + " WHERE " + CODEWHERESTRING);
}
string[] idInts = codeArr.AsEnumerable().Select(d => d.Field <string>("C_CODE")).ToArray();
string codesString = String.Join("','", idInts);
CommonClass conClass = new CommonClass();
IFeatureWorkspace ifw = conClass.GetFeatureWorkspaceByName(TABLENAME);
IQueryDef pQueryDef = ifw.CreateQueryDef();
pQueryDef.Tables = TABLENAME;
pQueryDef.SubFields = "count(*) as errorCount";
pQueryDef.WhereClause = FIELD + " IS NOT NULL AND " + FIELD + " <> '' AND " + FIELD + " not in ('" + codesString + "')";
ICursor pCur = pQueryDef.Evaluate();
IRow pRow = pCur.NextRow();
int iInx = pCur.Fields.FindField("errorCount");
string count = pRow.get_Value(iInx).ToString();
if (int.Parse(count) > 0)
{
List <string> listItem = new List <string>();
listItem.Add(CHECKTYPE);
listItem.Add(NAME);
listItem.Add(count);
listItem.Add(FIELD + " IS NOT NULL AND " + FIELD + " <> '' AND " + FIELD + " not in ('" + codesString + "')");
this.listError.Add(listItem);
}
nodeData["ERROR"] = count;
nodeData["ISCHECK"] = "已检查";
Marshal.ReleaseComObject(pCur);
}
else
{
nodeData["ERROR"] = "";
nodeData["ISCHECK"] = "未检查";
}
}
else if (DOMAINTYPE == "custom")
{
string CUSTOMVALUE = nodeData["CUSTOMVALUE"].ToString();
CommonClass conClass = new CommonClass();
IFeatureWorkspace ifw = conClass.GetFeatureWorkspaceByName(TABLENAME);
IQueryDef pQueryDef = ifw.CreateQueryDef();
pQueryDef.Tables = TABLENAME;
pQueryDef.SubFields = "count(*) as errorCount";
pQueryDef.WhereClause = FIELD + " not in (" + CUSTOMVALUE + ")";
ICursor pCur = pQueryDef.Evaluate();
IRow pRow = pCur.NextRow();
int iInx = pCur.Fields.FindField("errorCount");
string count = pRow.get_Value(iInx).ToString();
if (int.Parse(count) > 0)
{
List <string> listItem = new List <string>();
listItem.Add(CHECKTYPE);
listItem.Add(NAME);
listItem.Add(count);
listItem.Add(FIELD + " not in (" + CUSTOMVALUE + ")");
this.listError.Add(listItem);
}
nodeData["ERROR"] = count;
nodeData["ISCHECK"] = "已检查";
Marshal.ReleaseComObject(pCur);
}
}catch (Exception e)
{
LogHelper.WriteLog(typeof(FormAttrDia), e);
}
}
else if (CHECKTYPE == "项目名称检查")
{
try{
string[] arrStr = FIELD.Split('#');
string fieldStr = arrStr[0];
string taskfieldStr = "CONCAT(" + arrStr[1].Replace("&", ",") + ")";
CommonClass common = new CommonClass();
string gldwstr = common.GetConfigValue("GLDW");
DataTable xmmcArr = db.GetDataBySql("SELECT " + taskfieldStr + " AS XMMCARR FROM GISDATA_TASK WHERE YZLGLDW ='" + gldwstr + "'");
string[] idInts = xmmcArr.AsEnumerable().Select(d => d.Field <string>("XMMCARR")).ToArray();
string codesString = String.Join("','", idInts);
CommonClass conClass = new CommonClass();
IFeatureWorkspace ifw = conClass.GetFeatureWorkspaceByName(TABLENAME);
IQueryDef pQueryDef = ifw.CreateQueryDef();
pQueryDef.Tables = TABLENAME;
pQueryDef.SubFields = "count(*) as errorCount";
pQueryDef.WhereClause = fieldStr + " not in ('" + codesString + "')";
ICursor pCur = pQueryDef.Evaluate();
IRow pRow = pCur.NextRow();
int iInx = pCur.Fields.FindField("errorCount");
string count = pRow.get_Value(iInx).ToString();
if (int.Parse(count) > 0)
{
List <string> listItem = new List <string>();
listItem.Add(CHECKTYPE);
listItem.Add(NAME);
listItem.Add(count);
listItem.Add(fieldStr + " not in ('" + codesString + "')");
this.listError.Add(listItem);
}
nodeData["ERROR"] = count;
nodeData["ISCHECK"] = "已检查";
Marshal.ReleaseComObject(pCur);
}
catch (Exception e)
{
LogHelper.WriteLog(typeof(FormAttrDia), e);
LogHelper.WriteLog(typeof(FormAttrDia), "项目名称检查错误");
}
}
if (nodeData["ERROR"].ToString() != "0")
{
attrErrorTable.ImportRow(nodeData.Row);
}
XmlElement Xmlnode = doc.CreateElement("attr");
////创建bai用户du名节点
//XmlElement element1 = doc.CreateElement("ID");
//element1.InnerText = nodeData["ID"].ToString();
//Xmlnode.AppendChild(element1);
////创建密码节点
//XmlElement element2 = doc.CreateElement("ERROR");
//element2.InnerText = nodeData["ERROR"].ToString();
//Xmlnode.AppendChild(element2);
Attrs.AppendChild(Xmlnode);
XmlAttribute xa = doc.CreateAttribute("key");
xa.Value = nodeData["ID"].ToString();
XmlAttribute xa2 = doc.CreateAttribute("value");
xa2.Value = nodeData["ERROR"].ToString();
Xmlnode.SetAttributeNode(xa);
Xmlnode.SetAttributeNode(xa2);
}
if (node.Nodes.Count != 0)
{
loopCheck(node.Nodes, Attrs, doc);
}
}
}
}
public ActionResult DailyLog()
{
//Validate User Pemissions
@ViewBag.CreatePermission = CommonClass.GetPermission(SecurityAgency.Common.Utility.EnumUtility.Permissions.AddDailyLog);
return(View());
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
objCommonMIS.EmpId = Membership.GetUser().UserName.ToString();
objCommonMIS.BusinessLine_Sno = "2";
objCommonMIS.RegionSno = "0";
objCommonMIS.BranchSno = "0";
if (!Page.IsPostBack)
{
if (objCommonMIS.CheckLoogedInASC() > 0)
{
objCommonMIS.GetASCRegions(ddlRegion);
if (ddlRegion.Items.Count == 2)
{
ddlRegion.SelectedIndex = 1;
}
if (ddlRegion.Items.Count != 0)
{
objCommonMIS.RegionSno = ddlRegion.SelectedValue;
}
else
{
objCommonMIS.RegionSno = "0";
}
objCommonMIS.GetASCBranchs(ddlBranch);
if (ddlBranch.Items.Count == 2)
{
ddlBranch.SelectedIndex = 1;
}
objCommonMIS.BranchSno = ddlBranch.SelectedValue;
objCommonMIS.GetSCs(ddlASC);
if (ddlASC.Items.Count == 2)
{
ddlASC.SelectedIndex = 1;
}
objCommonMIS.GetASCProductDivisions(ddlProductDivison);
}
else
{
objCommonMIS.GetUserRegionsMTS_MTO(ddlRegion);
if (ddlRegion.Items.Count == 2)
{
ddlRegion.SelectedIndex = 1;
}
if (ddlRegion.Items.Count != 0)
{
objCommonMIS.RegionSno = ddlRegion.SelectedValue;
}
else
{
objCommonMIS.RegionSno = "0";
}
objCommonMIS.GetUserBranchs(ddlBranch);
if (ddlBranch.Items.Count == 2)
{
ddlBranch.SelectedIndex = 1;
}
objCommonMIS.BranchSno = ddlBranch.SelectedValue;
objCommonMIS.GetUserSCs(ddlASC);
if (ddlASC.Items.Count == 2)
{
ddlASC.SelectedIndex = 1;
}
objPendingDefectiveSpare.ASC_Id = 0;
objPendingDefectiveSpare.BindProductDivisionData(ddlProductDivison);
objPendingDefectiveSpare.ProductDivision_Id = 0;
}
ViewState["Column"] = "ASC_Name";
ViewState["Order"] = "ASC";
}
System.Threading.Thread.Sleep(int.Parse(ConfigurationManager.AppSettings["AjaxPleaseWaitTime"]));
}
catch (Exception ex)
{
CommonClass.WriteErrorErrFile(Request.RawUrl.ToString(), ex.StackTrace.ToString() + "-->" + ex.Message.ToString());
}
FillDropDownToolTip();
FillRegionDropDownToolTip();
FillBranchDropDownToolTip();
FillDivisionDropDownToolTip();
}
protected void Add_Save_Button_Command(object sender, CommandEventArgs e)
{
MySqlConnection dbconn = new MySqlConnection(CommonClass.connectionstring);
dbconn.Open();
string lPhotoFileName = null;
FileUpload lFileUpload1 = Product_Form_View.FindControl("FileUpload1") as FileUpload;
if (lFileUpload1.HasFile)
{
Random lRandom = new Random();
lPhotoFileName = lRandom.Next().ToString() + lFileUpload1.FileName;
lFileUpload1.SaveAs(Server.MapPath("~/img/" + lPhotoFileName));
}
else if (Product_Form_View.CurrentMode == FormViewMode.Edit)
{
Image lImage1 = Product_Form_View.FindControl("Product_Image") as Image;
if (lImage1.ImageUrl != "" && lImage1.ImageUrl != null)
{
string[] lImageUrgl = lImage1.ImageUrl.Split(new char[] { '/' });
lPhotoFileName = lImageUrgl[lImageUrgl.Length - 1];
}
}
string lProduct_Name = Server.HtmlEncode((Product_Form_View.FindControl("Product_Name") as TextBox).Text);
string lProductId = null;
if (Product_Form_View.CurrentMode == FormViewMode.Insert)
{
string[] lValues = CommonClass.ExecuteQuery("ADD_PRODUCT",
new string[]
{
"P_PRODUCT_NAME",
"P_PRODUCT_CATEGORY_ID",
"P_PHOTO_FILE_NAME",
"P_MEASUREMENT_ID",
"P_SUMMARY",
"P_HIGHLIGHT_TEXT"
},
new string[]
{
lProduct_Name,
(Product_Form_View.FindControl("PRODUCT_CATEGORY_ID") as DropDownList).SelectedValue.ToString(),
lPhotoFileName,
(Product_Form_View.FindControl("Measurement_Id") as DropDownList).SelectedValue.ToString(),
Server.HtmlEncode((Product_Form_View.FindControl("SUMMARY") as Obout.Ajax.UI.HTMLEditor.Editor).Content),
Server.HtmlEncode((Product_Form_View.FindControl("HIGHLIGHT_TEXT") as TextBox).Text)
},
new string[]
{
"P_PRODUCT_ID"
},
dbconn);
lProductId = lValues[0];
}
else
{
lProductId = Product_Form_View.DataKey.Values[0].ToString();
CommonClass.ExecuteQuery("UPDATE_PRODUCT",
new string[]
{
"P_PRODUCT_ID",
"P_PRODUCT_CATEGORY_ID",
"P_PRODUCT_NAME",
"P_MEASUREMENT_ID",
"P_HIGHLIGHT_TEXT",
"P_SUMMARY",
"P_PHOTO_FILE_NAME"
},
new string[]
{
lProductId,
(Product_Form_View.FindControl("Product_Category_Id") as DropDownList).SelectedValue.ToString(),
Server.HtmlEncode((Product_Form_View.FindControl("Product_Name") as TextBox).Text),
(Product_Form_View.FindControl("Measurement_Id") as DropDownList).SelectedValue.ToString(),
Server.HtmlEncode((Product_Form_View.FindControl("HIGHLIGHT_TEXT") as TextBox).Text),
Server.HtmlEncode((Product_Form_View.FindControl("SUMMARY") as AjaxControlToolkit.HTMLEditor.Editor).Content),
lPhotoFileName
},
dbconn);
}
Refresh_Product_View(dbconn);
dbconn.Close();
MultiView1.SetActiveView(Product_All_View);
}
public DataTable viewSubmitMessage(string userName)
{
CommonClass cc = new CommonClass();
return cc.reDt("select * from ApplyList where applier = '"+userName+"' order by applyDate desc");
}
protected void imgBtnUpdate_Click(object sender, EventArgs e)
{
try
{
if (hndEscalationId.Value != "")
{
//Assigning values to properties
objWSCEscalationMatrix.EscalationId = int.Parse(hndEscalationId.Value.ToString());
objWSCEscalationMatrix.RegionId = Convert.ToInt32(ddlRegion.SelectedValue.ToString());
objWSCEscalationMatrix.StateId = Convert.ToInt32(ddlState.SelectedValue.ToString());
objWSCEscalationMatrix.ProductdivisionId = Convert.ToInt32(ddlProductDiv.SelectedValue.ToString());
objWSCEscalationMatrix.To_UserId = Fn_Get_Value_ListBox(lstToUser);
objWSCEscalationMatrix.CC_UserId = Fn_Get_Value_ListBox(lstCCUser);
objWSCEscalationMatrix.To_UserId1 = Fn_Get_Value_ListBox(lstToUser1);
objWSCEscalationMatrix.CC_UserId1 = Fn_Get_Value_ListBox(lstCCUser1);
if (txtElaspTimeMatrix1.Text.Trim() == "")
{
objWSCEscalationMatrix.ElaspTimeMatrix1 = 0;
}
else
{
objWSCEscalationMatrix.ElaspTimeMatrix1 = Convert.ToInt32(txtElaspTimeMatrix1.Text.Trim());
}
objWSCEscalationMatrix.To_UserId2 = Fn_Get_Value_ListBox(lstToUser2);
//objWSCEscalationMatrix.CC_UserId2 = Fn_Get_Value_ListBox(lstCCUser2);
if (txtElaspTimeMatrix2.Text.Trim() == "")
{
objWSCEscalationMatrix.ElaspTimeMatrix2 = 0;
}
else
{
objWSCEscalationMatrix.ElaspTimeMatrix2 = Convert.ToInt32(txtElaspTimeMatrix2.Text.Trim());
}
objWSCEscalationMatrix.EmpCode = Membership.GetUser().UserName.ToString();
objWSCEscalationMatrix.ActiveFlag = rdoStatus.SelectedValue.ToString();
string strMsg = objWSCEscalationMatrix.SaveData("UPDATE_ESCALATION_MATRIX");
if (objWSCEscalationMatrix.ReturnValue == -1)
{
lblMessage.Text = CommonClass.getErrorWarrning(enuErrorWarrning.ErrorInStoreProc, enuMessageType.Error, false, "");
}
else
{
if (strMsg == "Exists")
{
lblMessage.Text = CommonClass.getErrorWarrning(enuErrorWarrning.ActivateStatusNotChange, enuMessageType.UserMessage, false, "");
}
else
{
lblMessage.Text = CommonClass.getErrorWarrning(enuErrorWarrning.RecordUpdated, enuMessageType.UserMessage, false, "");
}
}
}
}
catch (Exception ex)
{
//Writing Error message to File using CommonClass WriteErrorErrFile method taking arguments as URL of page
// trace, error message
CommonClass.WriteErrorErrFile(Request.RawUrl.ToString(), ex.StackTrace.ToString() + "-->" + ex.Message.ToString());
}
objCommonClass.BindDataGrid(gvComm, "uspWSCEscalationMatrix", true, sqlParamSrh, lblRowCount);
ClearControls();
}
public DIClass(CommonClass cc, TestClass tc)
{
tc.Value = 42;
TC = tc;
}
protected void Page_UnLoad(object sender, EventArgs e)
{
//null the both class object.
objCommonClass = null;
objRoutingMaster = null;
}
private bool CreateShapeFile(BaseControlGroup b)
{
string msg = string.Empty;
System.Data.DataSet ds;
string currentStat = string.Empty;
try
{
currentStat = _currentStat;
ModelDataLine modelDataLine = new ModelDataLine(); if (tabControl1.SelectedIndex == 0)
{
WaitShow("Loading model data file.");
modelDataLine.DatabaseFilePath = txtModelDatabase.Text;
System.Data.DataTable dtModel = CommonClass.ExcelToDataTable(txtModelDatabase.Text);
DataSourceCommonClass.UpdateModelDataLineFromDataSet(b.Pollutant, modelDataLine, dtModel);
}
else
{
StreamReader sr = new StreamReader(txtModelFile.Text);
string csvDataLine;
csvDataLine = "";
string fileDataLine;
fileDataLine = sr.ReadLine();
string[] sMatchArray = fileDataLine.Split(new char[] { ',' });
if (!(sMatchArray[0].Replace("\"", "") == b.Pollutant.PollutantName && sMatchArray[1] == b.GridType.GridDefinitionName && sMatchArray[2].Replace("\"", "") == "Model"))
{
MessageBox.Show("The pollutant or grid definition do not match.");
return(false);
}
WaitShow("Loading model data file...");
string strLine = "";
ds = new System.Data.DataSet();
DataTable dt = new DataTable();
DataRow dr = null;
string[] strArray;
strLine = sr.ReadLine();
if (strLine != null && strLine.Length > 0)
{
strArray = strLine.Split(',');
for (int i = 0; i < strArray.Count(); i++)
{
dt.Columns.Add(strArray[i]);
}
}
while (strLine != null)
{
strLine = sr.ReadLine();
if (strLine != null && strLine.Length > 0)
{
dr = dt.NewRow();
strArray = strLine.Split(',');
for (int i = 0; i < strArray.Count(); i++)
{
dr[i] = strArray[i];
}
dt.Rows.Add(dr);
}
}
ds.Tables.Add(dt);
modelDataLine.DatabaseFilePath = txtModelFile.Text;
DataSourceCommonClass.UpdateModelDataLineFromDataSetNewFormat(b.Pollutant, ref modelDataLine, ds);
sr.Close();
switch (currentStat)
{
case "baseline":
b.Base = null;
b.Base = modelDataLine;
b.Base.GridType = b.GridType;
break;
case "control":
b.Control = null;
b.Control = modelDataLine;
b.Control.GridType = b.GridType;
break;
}
}
System.Threading.Thread.Sleep(100); WaitClose();
switch (currentStat)
{
case "baseline":
b.Base = null;
b.Base = modelDataLine;
break;
case "control":
b.Control = null;
b.Control = modelDataLine;
break;
}
if (modelDataLine.ModelAttributes.Count == 0 && modelDataLine.ModelResultAttributes.Count == 0)
{
msg = "Error reading files.";
return(false);
}
int threadId = -1;
AsyncDelegate asyncD = new AsyncDelegate(AsyncCreateFile);
IAsyncResult ar = asyncD.BeginInvoke(b, modelDataLine, currentStat, out threadId, null, null);
return(true);
}
catch (Exception ex)
{
WaitClose();
Logger.LogError(ex);
return(false);
}
finally
{
if (msg != string.Empty)
{
MessageBox.Show(msg, "Error", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
}
protected void Page_UnLoad(object sender, EventArgs e)
{
objCommonClass = null;
objBusinessAreaMaster = null;
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
objCallRegistration.Type = "REGISTER_MTS_COMPLAINT";
objCallRegistration.CustomerID = int.Parse(hdnCustomerId.Value);
objCallRegistration.Prefix = ddlPrefix.SelectedValue.ToString();
objCallRegistration.FirstName = txtFirstName.Text.Trim();
objCallRegistration.MiddleName = txtMiddleName.Text.Trim();
objCallRegistration.LastName = txtLastName.Text.Trim();
objCallRegistration.CompanyName = txtCompanyName.Text.Trim();
objCallRegistration.OEMCustomerName = TxtOEMCustName.Text.Trim();
objCallRegistration.Address1 = txtAdd1.Text.ToString();
objCallRegistration.Address2 = txtAdd2.Text.ToString();
objCallRegistration.Landmark = txtLandmark.Text.Trim();
objCallRegistration.CountrySNo = Convert.ToInt32(DdlCountry.SelectedValue);
objCallRegistration.CountryName = DdlCountry.SelectedItem.Text;
objCallRegistration.City = txtCity.Text.Trim();
objCallRegistration.Email = txtEmail.Text.Trim();
objCallRegistration.ContactNo = txtContactNo.Text.Trim();
objCallRegistration.AlternateContactNo = txtAltConatctNo.Text.Trim();
objCallRegistration.Extension = txtExtension.Text.Trim();
objCallRegistration.ProductDivSNo = Convert.ToInt32(ddlProductDiv.SelectedValue);
objCallRegistration.ProductLineSno = Convert.ToInt32(ddlProductLine.SelectedValue);
objCallRegistration.ProductGroupSNo = Convert.ToInt32(ddlProductGroup.SelectedValue);
objCallRegistration.ProductSNo = Convert.ToInt32(ddlProduct.SelectedValue);
if (!String.IsNullOrEmpty(txtPurchaseDate.Text.Trim()))
{
objCallRegistration.PurchaseDate = txtPurchaseDate.Text.Trim();
}
objCallRegistration.PurchaseFrom = txtDealerName.Text.Trim();
objCallRegistration.InvoiceNo = txtInvoiceNum.Text.Trim();
objCallRegistration.Remarks = txtComplaintDetails.Text.Trim();
objCallRegistration.LoggedBy = TxtLoggedBy.Text.Trim(); // Bhawesh 16-4-13
objCallRegistration.RegisterMTSComplaint();
ArrayList arrListFiles = new ArrayList();
//Inserting DraftComplaintDetails
if (objCallRegistration.CustomerID > 0)
{
#region Upload file
//uploading Files to Server on Folder Docs/Customer
strFileSavePath = ConfigurationSettings.AppSettings["CustomerFilePath"].ToString();
dTableFile = (DataTable)ViewState["dTableFile"];
if (flUpload.Value != "")
{
try
{
if (!Directory.Exists(strFileSavePath))
{
Directory.CreateDirectory(Server.MapPath(strFileSavePath));
}
strvFileName = flUpload.Value;
strFileName = Path.GetFileName(strvFileName);
strExt = Path.GetExtension(strvFileName);
strFileName = Path.GetFileNameWithoutExtension(strvFileName) + "_" + DateTime.Now.Day.ToString() + DateTime.Now.Month.ToString() + DateTime.Now.Year.ToString() + DateTime.Now.Hour.ToString() + DateTime.Now.Minute.ToString() + DateTime.Now.Second.ToString();
strFileName = strFileName + strExt;
DataRow dRow = dTableFile.NewRow();
dRow["FileName"] = strFileName;
dTableFile.Rows.Add(dRow);
ViewState["dTableFile"] = dTableFile;
flUpload.PostedFile.SaveAs(Server.MapPath(strFileSavePath + strFileName));
}
catch (Exception ex)
{
CommonClass.WriteErrorErrFile(Request.RawUrl.ToString(), ex.StackTrace.ToString() + "-->" + ex.Message.ToString());
}
}
dTableFile = (DataTable)ViewState["dTableFile"];
for (intCnt = 0; intCnt < dTableFile.Rows.Count; intCnt++)
{
arrListFiles.Add(dTableFile.Rows[intCnt]["FileName"].ToString());
}
//Uploading Files End
#endregion Upload file
//Create Temp table for Complaint + SC Name
DataTable dTableTemp = new DataTable();
DataColumn dColNo = new DataColumn("SNo");
DataColumn dColComplaintNo = new DataColumn("ComplaintRefNo");
DataColumn dColProd = new DataColumn("ProductDivision");
dTableTemp.Columns.Add(dColNo);
dTableTemp.Columns.Add(dColComplaintNo);
dTableTemp.Columns.Add(dColProd);
if (objCallRegistration.ReturnValue == 1)
{
#region Save FileData
RequestRegistration objCallreg = new RequestRegistration();
//Saving FileNames to DB
for (int i = 0; i < arrListFiles.Count; i++)
{
objCallreg.EmpCode = Membership.GetUser().UserName.ToString();
objCallreg.Type = "INSERT_COMPLAINT_FILES_DATA";
objCallreg.SaveFilesWithComplaintno(objCallRegistration.Complaint_RefNoOUT, arrListFiles[i].ToString());
}
objCallreg = null;
//End Saving
#endregion Save FileData
#region For Display Final Grid
//Creating row for temp table
DataRow dRowTEMP = dTableTemp.NewRow();
dRowTEMP["SNo"] = dTableTemp.Rows.Count + 1;
dRowTEMP["ProductDivision"] = ddlProductDiv.SelectedItem.Text;
dRowTEMP["ComplaintRefNo"] = objCallRegistration.Complaint_RefNoOUT;
dTableTemp.Rows.Add(dRowTEMP);
btnNext.Visible = true;
btnNext.CommandArgument = objCallRegistration.Complaint_RefNoOUT;
#endregion For Display Final Grid
}
//Assigning DataSource to Grid
gvFinal.DataSource = dTableTemp;
gvFinal.DataBind();
//End
//Clear Files For File Upload Grid
dTableFile = (DataTable)ViewState["dTableFile"];
dTableFile.Rows.Clear();
ViewState["dTableFile"] = dTableFile;
gvFiles.Visible = false;
//End
//Clear Product Grid
btnSubmit.CausesValidation = true;
tableResult.Visible = true;
btnSubmit.Enabled = false;
btnCancel.Enabled = false;
ClearControls();
lblMsg.Text = "";
}
}
private void textBox1_KeyPress(object sender, KeyPressEventArgs e)
{
if (e.KeyChar == (char)Keys.Enter)
{
string strXHTM = this.textBox1.Text.Trim();
string strCPBH = (string)DataClass.GetValue("select cpbh from pdlots with(nolock) where prodno=(select 生产制令号 from 成品条码表_3M where 箱号条码='" + strXHTM + "')");
if (strCPBH == null)
{
MessageBox.Show("此条码并不存在！");
this.Clear();
return;
}
this.cpbh = strCPBH;
string file1 = "", file2 = "", file3 = "";
//导通检查
switch (this.CheckFiles(this.paths_dt, strXHTM, ref file1))
{
case 1:
this.checkBox1.Checked = true;
break;
case 0:
MessageBox.Show("导通测试未通过！");
this.Clear();
return;
case -1:
MessageBox.Show("网络异常，无法访问导通测试目录，请联系电脑工程师！");
this.Clear();
return;
}
//烧录检查
switch (this.CheckFiles(this.paths_sl, strXHTM, ref file2))
{
case 1:
this.checkBox2.Checked = true;
break;
case 0:
MessageBox.Show("烧录测试未通过！");
this.Clear();
return;
case -1:
MessageBox.Show("网络异常，无法访问烧录测试目录，请联系电脑工程师！");
this.Clear();
return;
}
//高频检查
switch (this.CheckFiles(this.paths_gp, strXHTM, ref file3))
{
case 1:
this.checkBox3.Checked = true;
break;
case 0:
MessageBox.Show("高频测试未通过！");
this.Clear();
return;
case -1:
MessageBox.Show("网络异常，无法访问高频测试目录，请联系电脑工程师！");
this.Clear();
return;
}
//更新数据库
string sql = "update 成品条码表_3M set 测试通过=1,测试时间=getdate(),导通测试文件='" + file1 + "',烧录测试文件='" + file2 + "',高频测试文件='" + file3 + "' where 箱号条码='" + strXHTM + "'";
if (DataClass.Execute(sql))
{
CommonClass.PlaySoundOK();
MessageBox.Show("测试通过！");
}
else
{
CommonClass.PlaySoundNG();
MessageBox.Show("保存到数据库失败，请重新尝试或联系系统管理员！");
}
this.Clear();
}
}
protected void Page_UnLoad(object sender, EventArgs e)
{
objCommonClass = null;
objCallRegistration = null;
objSCPopupMaster = null;
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
try
{
//Assigning values to properties
objwscCustomerComplaint.WSCCustomerId = hdnWSCCustomerId.Value;
objwscCustomerComplaint.Prefix = ddlPrefix.SelectedValue.ToString();
objwscCustomerComplaint.FileName = txtFirstName.Text.Trim();
objwscCustomerComplaint.LastName = txtLastName.Text.Trim();
objwscCustomerComplaint.Address = txtAdd1.Text.Trim();
objwscCustomerComplaint.Company_Name = txtCompanyName.Text.Trim();
objwscCustomerComplaint.Contact_No = txtContactNo.Text.Trim();
objwscCustomerComplaint.Country_Sno = Convert.ToInt32(ddlCountry.SelectedValue);
objwscCustomerComplaint.State_Sno = Convert.ToInt32(ddlState.SelectedValue);
objwscCustomerComplaint.City_Sno = Convert.ToInt32(ddlCity.SelectedValue);
objwscCustomerComplaint.Email = txtEmail.Text.Trim();
objwscCustomerComplaint.Feedback_Type = Convert.ToInt32(ddlFeedbackType.SelectedValue);
objwscCustomerComplaint.Feedback = txtfeedback.Text.Trim();
objwscCustomerComplaint.ProductDivisionId = Convert.ToInt32(ddlProductDiv.SelectedValue);
objwscCustomerComplaint.ProductLineId = Convert.ToInt32(ddlProductLine.SelectedValue);
objwscCustomerComplaint.Rating_Voltage = txtRating.Text.Trim();
objwscCustomerComplaint.Manufacturer_Serial_No = txtManufacturerSerialNo.Text.Trim();
objwscCustomerComplaint.Manufacture_Year = txtxPurchaseDate.Text.Trim();
objwscCustomerComplaint.Site_Location = txtlocation.Text.Trim();
objwscCustomerComplaint.Nature_of_Complaint = txtCompNature.Text.Trim();
objwscCustomerComplaint.CGExe_Feedback = Convert.ToInt32(ddlGCExecutive.SelectedValue.ToString());
objwscCustomerComplaint.CGExe_Comment = txtCGExecutive.Text.Trim();
objwscCustomerComplaint.EmpCode = Membership.GetUser().UserName.ToString();
//uploading Files to Server on Folder Docs/Customer
ArrayList arrListFiles = new ArrayList();
strFileSavePath = ConfigurationSettings.AppSettings["CustomerFilePath"].ToString();
dTableFile = (DataTable)ViewState["dTableFile"];
if (flUpload.Value != "")
{
try
{
if (!Directory.Exists(strFileSavePath))
{
Directory.CreateDirectory(Server.MapPath(strFileSavePath));
}
strvFileName = flUpload.Value;
strFileName = Path.GetFileName(strvFileName);
strExt = Path.GetExtension(strvFileName);
strFileName = Path.GetFileNameWithoutExtension(strvFileName) + "_" + DateTime.Now.Day.ToString() + DateTime.Now.Month.ToString() + DateTime.Now.Year.ToString() + DateTime.Now.Hour.ToString() + DateTime.Now.Minute.ToString() + DateTime.Now.Second.ToString();
strFileName = strFileName + strExt;
DataRow dRow = dTableFile.NewRow();
dRow["FileName"] = strFileName;
dTableFile.Rows.Add(dRow);
ViewState["dTableFile"] = dTableFile;
flUpload.PostedFile.SaveAs(Server.MapPath(strFileSavePath + strFileName));
}
catch (Exception ex)
{
CommonClass.WriteErrorErrFile(Request.RawUrl.ToString(), ex.StackTrace.ToString() + "-->" + ex.Message.ToString());
}
}
dTableFile = (DataTable)ViewState["dTableFile"];
for (intCnt = 0; intCnt < dTableFile.Rows.Count; intCnt++)
{
arrListFiles.Add(dTableFile.Rows[intCnt]["FileName"].ToString());
}
//Uploading Files End
objwscCustomerComplaint.SaveComplaint("UPDATE_CUSTOMER_INFORMATION");
if (objwscCustomerComplaint.ReturnValue == -1)
{
lblMsg.Text = CommonClass.getErrorWarrning(enuErrorWarrning.ErrorInStoreProc, enuMessageType.Error, false, "");
}
else
{
// Save FileData
RequestRegistration objCallreg = new RequestRegistration();
for (int i = 0; i < arrListFiles.Count; i++)
{
objwscCustomerComplaint.SaveFiles(objwscCustomerComplaint.WebRequest_RefNo, arrListFiles[i].ToString());
}
//End Saving
lblMsg.Text = CommonClass.getErrorWarrning(enuErrorWarrning.AddRecord, enuMessageType.UserMessage, false, "");
//Clear Files For File Upload Grid
dTableFile = (DataTable)ViewState["dTableFile"];
dTableFile.Rows.Clear();
ViewState["dTableFile"] = dTableFile;
BindGridFiles();
gvFiles.Visible = false;
//End
if (ddlFeedbackType.SelectedValue == "1")
{
//if (hdnProductSrno.Value != "0" || hdnProductSrno.Value != "")
//{
//Assign Value in Session
Session["PRODUCTSRNO"] = hdnProductSrno.Value;
Response.Redirect("../pages/MTOServiceRegistration.aspx");
//End
//Response.Redirect
//HttpContext.Current.Items.Add("PRODUCTSRNO", hdnProductSrno.Value);
//Server.Transfer("../pages/MTOServiceRegistration.aspx",false);
//}
}
else
{
sqlParamSrh[1].Value = ddlSearch.SelectedValue.ToString();
sqlParamSrh[2].Value = txtSearch.Text.Trim();
objCommonClass.BindDataGrid(gvComm, "uspWSCCustomerRegistration", true, sqlParamSrh, lblRowCount);
ClearControls();
}
}
}
catch (Exception ex)
{
//Writing Error message to File using CommonClass WriteErrorErrFile method taking arguments as URL of page
// trace, error message
CommonClass.WriteErrorErrFile(Request.RawUrl.ToString(), ex.StackTrace.ToString() + "-->" + ex.Message.ToString());
}
}
protected void Calculate_Grand_Total()
{
GLOBAL_DISCOUNT_APPLIED.Value = "0";
MySqlConnection dbconn = new MySqlConnection(CommonClass.connectionstring);
dbconn.Open();
Dictionary <string, string> parameters = Get_Global_Discounts(dbconn);
double lGrandTotal = 0.0;
double lShippingCharges = 0.0;
double lTotalQuantity = 0.0;
double lDiscounts = 0.0;
foreach (ListViewItem item in Product_ListView.Items)
{
ListView lv = (ListView)item.FindControl("Product_Order_ListView");
foreach (ListViewItem item1 in lv.Items)
{
DropDownList ddl = (DropDownList)item1.FindControl("Quantity_Dropdown");
double lQuantity = int.Parse(ddl.SelectedValue);
double lSize = double.Parse(lv.DataKeys[item1.DataItemIndex].Values[1].ToString());
if (lv.DataKeys[item1.DataItemIndex].Values[4].ToString() == "Litre")
{
lTotalQuantity += (lQuantity * lSize);
}
lGrandTotal += double.Parse((item1.FindControl("Subtotal") as Label).Text);
double lShippingCharge = double.Parse(lv.DataKeys[item1.DataItemIndex].Values[3].ToString());
if (Delivery_Method.SelectedValue == "" || Delivery_Method.SelectedValue == "3")
{
lShippingCharges += (lQuantity * lShippingCharge);
}
string lstr = lv.DataKeys[item1.DataItemIndex].Values[0].ToString() + "-" + lv.DataKeys[item1.DataItemIndex].Values[1].ToString();
//Response.Write(lstr + "<br>");
if (parameters.ContainsKey(lstr))
{
// Response.Write(lQuantity + "<br>");
// Response.Write(parameters[lstr] + "<br>");
lDiscounts += (lQuantity * double.Parse(parameters[lstr]));
GLOBAL_DISCOUNT_APPLIED.Value = "1";
}
}
}
Shipping_Charges.Text = lShippingCharges.ToString();
Subtotal_Str.Text = lGrandTotal.ToString();
string[] lRecords = CommonClass.FetchRecords("GET_ACTIVE_PROMOTIONS",
new string[]
{
"PROMOTION_TYPE"
},
new string[]
{
"GLOBAL"
},
new string[]
{
"P_PROMOTION_ID",
"P_TOTAL_QUANTITY",
"P_TOTAL_ORDER"
},
dbconn
);
dbconn.Close();
string lPromotionId = lRecords[0];
int lDiscountedQuantity = int.Parse(lRecords[1]);
GLOBAL_PROMOTION_ID.Value = "";
if (USER_TYPE_ID.Value == "0")
{
lDiscounts = lShippingCharges;
Shipping_Discount.Text = lShippingCharges.ToString();
double lDiscountValue = 0;
if (DISCOUNT.Value != null && DISCOUNT.Value != "")
{
lDiscountValue = double.Parse(DISCOUNT.Value);
}
if (lDiscountValue > 0)
{
if (DISCOUNT_MEASUREMENT_ID.Value == "1")
{
lDiscounts += lTotalQuantity * lDiscountValue;
}
else if (DISCOUNT_MEASUREMENT_ID.Value == "2")
{
lDiscounts += (lGrandTotal * lDiscountValue) / 100;
}
}
}
else
{
if (lTotalQuantity >= lDiscountedQuantity || SHIPPING_CHARGE_DISCOUNT_FLAG.Value == "Y")
{
GLOBAL_PROMOTION_ID.Value = lPromotionId;
lDiscounts += lShippingCharges;
Shipping_Discount.Text = lShippingCharges.ToString();
}
}
//Promotion Discount
if (Promotion_Id.Value != "")
{
if (lGrandTotal > 0.0)
{
if (Promotion_Amount.Value != "")
{
lDiscounts += double.Parse(Promotion_Amount.Value);
}
else if (Promotion_Percentage.Value != "")
{
double lPromotionDiscount = (lGrandTotal * double.Parse(Promotion_Percentage.Value)) / 100;
double lPromotionMaximum = double.Parse(Promotion_Maximum.Value);
if (lPromotionMaximum > 0)
{
lDiscounts += Math.Min(lPromotionDiscount, lPromotionMaximum);
}
else
{
lDiscounts += lPromotionDiscount;
}
}
}
}
Discounts.Text = lDiscounts.ToString();
Grand_Total.Text = (lGrandTotal + lShippingCharges - lDiscounts).ToString();
}
protected void Create_CC_Payment(Dictionary <string, string> pParameters)
{
MySqlConnection dbconn = new MySqlConnection(CommonClass.connectionstring);
dbconn.Open();
string lTxnDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
string lTxnAmount = "";
string lTxnId = "";
string lOrderId = pParameters["order_id"];
if (pParameters.ContainsKey("trans_date"))
{
lTxnDate = pParameters["trans_date"];
}
if (pParameters.ContainsKey("amount"))
{
lTxnAmount = pParameters["amount"];
}
if (pParameters.ContainsKey("tracking_id"))
{
lTxnId = pParameters["tracking_id"];
}
string[] lRecords = CommonClass.FetchRecords("ADD_CC_AVANUE_PAYMENT",
new string[]
{
"P_ORDER_ID",
"P_PAYMENT_DATE",
"P_PAYMENT_AMOUNT",
"P_TRACKING_ID",
"P_PAYMENT_MODE",
"P_TRANSACTION_STATUS",
"P_FAILURE_MESSAGE",
"P_EXTERNAL_USER_ID",
"P_USER_ID"
},
new string[]
{
lOrderId,
lTxnDate,
lTxnAmount,
lTxnId,
pParameters["payment_mode"],
pParameters["order_status"],
pParameters["failure_message"],
ClaimsPrincipal.Current.FindFirst("user_id").Value,
null
},
new string[]
{
"P_ERROR_STRING"
},
dbconn);
if ((!(lRecords[0] != null && lRecords[0] != "")) && pParameters["order_status"] == "Success")
{
OrderClass.Confirm_Order(dbconn, pParameters["order_id"]);
}
dbconn.Close();
Session.Abandon();
Session.Clear();
Response.Redirect("~/OrderSummary.aspx?Order_Id=" + lOrderId);
}
protected void Order_Form_OnCommand(object sender, CommandEventArgs e)
{
Message.Text = "";
if (e.CommandName == "Place Order")
{
if (Page.IsValid && Validate_Order())
{
MySqlConnection dbconn = new MySqlConnection(CommonClass.connectionstring);
dbconn.Open();
string lDeliveryMethod = "3"; // To be couriered
if (Delivery_Method.SelectedValue != "")
{
lDeliveryMethod = Delivery_Method.SelectedValue;
}
string[] lRecords = CommonClass.ExecuteQuery("ADD_ORDER1",
new string[]
{
"P_USER_ID",
"P_EXTERNAL_USER_ID",
"P_ORDER_TOTAL",
"P_SHIPPING_CHARGE",
"P_DISCOUNTS",
"P_ADDRESS_ID",
"P_PROMOTION_ID",
"P_PAYMENT_TYPE",
"P_STATUS",
"P_DELIVERY_METHOD"
},
new string[]
{
USER_ID.Value,
ClaimsPrincipal.Current.FindFirst("user_id").Value,
Grand_Total.Text,
Shipping_Charges.Text,
Discounts.Text,
AddressBook1.GetDeliveryAddressId,
Promotion_Id.Value,
PAYMENT_TYPE_ID.Value,
ORDER_STATUS.Value,
lDeliveryMethod
},
new string[]
{
"P_ORDER_ID"
},
dbconn);
foreach (ListViewItem item in Product_ListView.Items)
{
ListView lv = (ListView)item.FindControl("Product_Order_ListView");
foreach (ListViewItem item1 in lv.Items)
{
Label lSubtotalLabel = item1.FindControl("Subtotal") as Label;
if (lSubtotalLabel.Text != "0" && lSubtotalLabel.Text != "0.0")
{
CommonClass.ExecuteQuery("ADD_ORDER_DETAILS",
new string[]
{
"P_ORDER_ID",
"P_PRODUCT_ID",
"P_MEASUREMENT_UNIT",
"P_QUANTITY",
"P_PRICE"
},
new string[]
{
lRecords[0],
lv.DataKeys[item1.DataItemIndex].Values[0].ToString(),
lv.DataKeys[item1.DataItemIndex].Values[1].ToString(),
(item1.FindControl("Quantity_DropDown") as DropDownList).SelectedValue.ToString(),
lv.DataKeys[item1.DataItemIndex].Values[2].ToString()
},
dbconn
);
}
}
}
ORDER_ID.Value = lRecords[0];
if (PAYMENT_TYPE_ID.Value == "Cash")
{
PaymentClass.Create_Cash_Payment(dbconn,
Grand_Total.Text,
USER_ID.Value);
}
//string lPaymentType = "";
//if (PAYMENT_TYPE_ID.Value != "" && PAYMENT_TYPE_ID.Value != null)
//{
// MySqlCommand dbcomm = new MySqlCommand("SELECT GET_ATTRIBUTE_VALUE(GET_PAYMENT_TYPE_MASTER_TYPE(), " + PAYMENT_TYPE_ID.Value + ")", dbconn);
// MySqlDataReader reader = dbcomm.ExecuteReader();
// while (reader.Read())
// {
// lPaymentType = reader[0].ToString();
// }
// reader.Close();
// }
if (PAYMENT_TYPE_ID.Value == WalletPaymentType)
{
UserModel lUserModel = CommonClass.Get_External_User_Profile(dbconn);
PaymentClass.Initiate_PayTm_Order(ORDER_ID.Value,
Grand_Total.Text,
lUserModel.Email_Address,
lUserModel.Mobile_Number);
dbconn.Close();
}
else if (PAYMENT_TYPE_ID.Value == OthersPaymentType)
{
UserModel lUserModel = CommonClass.Get_External_User_Profile(dbconn);
PaymentClass.Initiate_CCAvenue_Order(ORDER_ID.Value,
Grand_Total.Text,
lUserModel.Email_Address,
lUserModel.Mobile_Number,
AddressBook1.GetDeliveryAddressId,
dbconn);
dbconn.Close();
}
else
{
OrderClass.Confirm_Order(dbconn, ORDER_ID.Value);
dbconn.Close();
if (SuccessOrder != null)
{
SuccessOrder(this, EventArgs.Empty);
}
}
}
}
}
private void EnterEvent(object sender, EventArgs e)
{
CommonClass.EnterEvents(sender, e);
}
private void BindSearchSection()
{
try
{
// For Upload Excel File
CommonClass obj = new CommonClass();
if (Roles.FindUsersInRole(_userRole, objDdl.EmpId).Any())
{
objDdl.BindAllRegion(ddlRegion);
//objDdl.BindProductDivision(ddlPdivision); Not visibile in case of Admin for upload records.
if (ddlRegion.Items.FindByValue("8") != null)
{
ListItem lstRegionSearch = ddlRegion.Items.FindByValue("8");
ddlRegion.Items.Remove(lstRegionSearch);
}
}
else
{
objcmb.Role = obj.GetRolesForUser(objDdl.EmpId);
if (objcmb.Role.Contains("SC") == true)
{
objcmb.Role = "SC";
ddlRegion.Items.Clear();
ddlBranchSearch.Items.Clear();
ddlRegion.Enabled = false;
ddlBranchSearch.Enabled = false;
objDdl.EmpId = Membership.GetUser().UserName;
objDdl.RegionSno = 0;
objDdl.BranchSno = 0;
GetUserSCs(ddlServicecontractorSearch, objDdl.EmpId);
// objDdl.BindProductDivision(ddlproddivision);
ListItem removeItems = ddlServicecontractorSearch.Items.FindByValue("0");
ddlServicecontractorSearch.Items.Remove(removeItems);
}
else
{
if (objcmb.Role.Contains("AISH") == true)
{
objcmb.Role = "AISH";
}
if (objcmb.Role.Contains("RSH") == true)
{
objcmb.Role = "RSH";
}
else if (objcmb.Role.Contains("EIC") == true)
{
objcmb.Role = "EIC";
}
objcmb.EmpId = Membership.GetUser().UserName;
objcmb.GetUserRegionsByRoleMts(ddlRegion);
if (ddlRegion.Items.FindByValue("8") != null)
{
ListItem lstRegion = ddlRegion.Items.FindByValue("8");
ddlRegion.Items.Remove(lstRegion);
}
objcmb.RegionSno = int.Parse(ddlRegion.SelectedValue);
objcmb.GetUserBranchsByRole(ddlBranchSearch);
ddlBranchSearch.Items.Insert(0, new ListItem("Select", "1111"));
objcmb.BranchSno = int.Parse(ddlBranchSearch.SelectedValue);
if (ddlRegion.Items.Count > 1)
{
ddlRegion.SelectedValue = "0";
}
}
objDdl.BindProductDivision(ddlproddivision);
ListItem removeItem = ddlproddivision.Items.FindByValue("0");
ddlproddivision.Items.Remove(removeItem);
ddlproddivision.Items.Insert(0, new ListItem("All", "0"));
}
}
catch (Exception ex)
{
}
}
/// <summary>
/// 根据连接字符串返回单周课表
/// </summary>
/// <param name="weekNum">第几周</param>
/// <param name="sqlstr">连接字符串（需包含第几周intDay第几节intStartNum,intEndNum等信息）</param>
/// <param name="printstr">单元格要显示的内容</param>
public static DataTable PrintTab_Week_DT(int weekNum, string sqlstr, string printstr)
{
sqlstr = sqlstr + " and intweek = " + weekNum;
SqlConnection con = CommonClass.GetSqlConnection();
SqlDataAdapter sda = new SqlDataAdapter();
sda.SelectCommand = new SqlCommand(sqlstr, con);
DataSet ds = new DataSet();
sda.Fill(ds);
DataTable table = new DataTable();
table = ds.Tables[0];
DataTable dtSchedule = new DataTable();
//添加八列
dtSchedule.Columns.Add("查询");
for (int i = 1; i < 8; i++)
{
dtSchedule.Columns.Add(Convert.ToString(i));
}
//添加10行
for (int i = 0; i < 11; i++)
{
dtSchedule.Rows.Add();
}
//添加左侧固定信息（第几节）
for (int i = 0; i < 11; i++)
{
dtSchedule.Rows[i][0] = (i + 1);
}
//此数组用于存放需要合并的单元格信息。如：需要合并第一列的一、二单元格
//那么，数组中一行的三个数分别为1,1,2
int[][] tempArray = new int[table.Rows.Count][];
for (int i = 0; i < table.Rows.Count; i++)
{
tempArray[i] = new int[3];
for (int j = 0; j < 3; j++)
{
tempArray[i][j] = 0;
}
}
//遍历table，将每条课表信息填在tab中适当的位置。
for (int i = 0; i < table.Rows.Count; i++)
{
//Day
string week = Convert.ToString(table.Rows[i]["intDay"]);
//StartNum
//string startNum = Convert.ToString(table.Rows[i]["intStartNum"]);
string startNum = "";
if (Convert.ToInt16(table.Rows[i]["intStartNum"]) <= 4)
{
startNum = Convert.ToString(table.Rows[i]["intStartNum"]);
}
if ((Convert.ToInt16(table.Rows[i]["intStartNum"]) >= 5) && (Convert.ToInt16(table.Rows[i]["intStartNum"]) <= 10))
{
startNum = (Convert.ToInt16(table.Rows[i]["intStartNum"]) + 1).ToString();
}
if (Convert.ToInt16(table.Rows[i]["intStartNum"]) == 99)
{
startNum = "5";
}
//EndNum
//string endNum = Convert.ToString(table.Rows[i]["intEndNum"]);
string endNum = "";
if (Convert.ToInt16(table.Rows[i]["intEndNum"]) <= 4)
{
endNum = Convert.ToString(table.Rows[i]["intEndNum"]);
}
if ((Convert.ToInt16(table.Rows[i]["intEndNum"]) >= 5) && (Convert.ToInt16(table.Rows[i]["intEndNum"]) <= 10))
{
endNum = (Convert.ToInt16(table.Rows[i]["intEndNum"]) + 1).ToString();
}
if (Convert.ToInt16(table.Rows[i]["intEndNum"]) == 99)
{
endNum = "5";
}
for (int weekCount = 1; weekCount < 8; weekCount++) //确定本条数据将来显示在哪一列
{
if (week == Convert.ToString(dtSchedule.Columns[weekCount].ColumnName)) //跟星期做比较，确定数据应该写在那一列
{
tempArray[i][0] = weekCount; //记录星期（确定将来的数据显示在哪一列）
break;
}
}
for (int j = 0; j < dtSchedule.Rows.Count; j++) //确定课程的开始时间和结束时间，并填写数据
{
string section = Convert.ToString(dtSchedule.Rows[j][0]); //当前行是第几节课
string sRoom = Convert.ToString(table.Rows[i]["strRoomName"]);
string sName = Convert.ToString(table.Rows[i]["strName"]);
string sClass = Convert.ToString(table.Rows[i]["strClass"]);
string sTeacher = Convert.ToString(table.Rows[i]["strTeacher"]);
string sStartN = Convert.ToString(table.Rows[i]["intStartNum"]);
string sEndN = Convert.ToString(table.Rows[i]["intEndNum"]);
string sDay = Convert.ToString(table.Rows[i]["intDay"]);
string sTemp = string.Empty;
switch (printstr)
{
case "NCT": sTemp = sName + "<br />" + sClass + "<br />" + sTeacher; break;
case "RNT": sTemp = sRoom + "<br />" + sName + "<br />" + sTeacher; break;
case "RNC": sTemp = sRoom + "<br />" + sName + "<br />" + sClass; break;
default: sTemp = sRoom + "-" + sName + "-" + sClass + "-" + sTeacher + "-" + sStartN + sEndN + "-星期" + sDay + "<br />"; break;
}
if (section == startNum) //判断课程开始时间，确定位置，填写数据
{
tempArray[i][1] = j; //记录上课开始时间（确定数据显示在哪一行）
dtSchedule.Rows[j][tempArray[i][0]] = dtSchedule.Rows[j][tempArray[i][0]].ToString() + sTemp;
}
if ((Convert.ToInt16(section) > Convert.ToInt16(startNum)) && (Convert.ToInt16(section) < Convert.ToInt16(endNum)))
{
dtSchedule.Rows[j][tempArray[i][0]] = dtSchedule.Rows[j][tempArray[i][0]].ToString() + sTemp;
}
if (section == endNum) //判断课程结束时间，记录位置
{
tempArray[i][2] = j; //记录课结束时间
if (startNum != endNum) //如开始时间等于结束时间则会重复记录
{
dtSchedule.Rows[j][tempArray[i][0]] = dtSchedule.Rows[j][tempArray[i][0]].ToString() + sTemp;
}
break;
}
}
}
//修改行标题
for (int i = 1; i < 8; i++)
{
dtSchedule.Columns[i].ColumnName = "星期" + CommonClass.WeekConvertToChinese(i);
}
//修改列标题
//for (int i = 0; i < 10; i++)
//{
// dtSchedule.Rows[i][0] = "第" + CommonClass.ConvertToChinese(i + 1) + "节";
//}
for (int i = 0; i < 4; i++)
{
dtSchedule.Rows[i][0] = "第" + ConvertToChinese2(i + 1) + "节";
}
dtSchedule.Rows[4][0] = "中午";
for (int i = 5; i < 11; i++)
{
dtSchedule.Rows[i][0] = "第" + ConvertToChinese2(i + 1) + "节";
}
//dispose
table.Dispose();
ds.Dispose();
sda.Dispose();
con.Dispose();
return(dtSchedule);
}
public Main()
{
try
{
InitializeComponent();
CheckFirebirdAndStartFirebird();
_baseFormTitle = this.Text + Assembly.GetExecutingAssembly().GetName().Version.ToString().Substring(0, Assembly.GetExecutingAssembly().GetName().Version.ToString().Count() - 2); mnuOverview.Text = "Quick-Start Guide"; this.Text = _baseFormTitle;
string sPicName = "";
CommonClass.ActiveSetup = "USA";
string commandText = "select SetupID,SetupName from Setups order by SetupID";
ESIL.DBUtility.FireBirdHelperBase fb = new ESIL.DBUtility.ESILFireBirdHelper();
System.Data.DataSet ds = fb.ExecuteDataset(CommonClass.Connection, CommandType.Text, commandText);
string iniPath = CommonClass.ResultFilePath + @"\BenMAP.ini";
string defaultSetup = "United States";
if (System.IO.File.Exists(iniPath))
{
defaultSetup = CommonClass.IniReadValue("appSettings", "DefaultSetup", iniPath);
}
else
{
CommonClass.IniWriteValue("appSettings", "IsShowStart", "T", iniPath);
CommonClass.IniWriteValue("appSettings", "IsShowExit", "T", iniPath);
CommonClass.IniWriteValue("appSettings", "DefaultSetup", "United States", iniPath);
}
DataRow[] drs = ds.Tables[0].Select("SetupName='" + defaultSetup + "'");
DataRow dr;
if (drs != null && drs.Count() > 0)
{
dr = drs[0];
}
else
{
dr = ds.Tables[0].Rows[0];
CommonClass.IniWriteValue("appSettings", "DefaultSetup", dr["SetupName"].ToString(), iniPath);
}
BenMAPSetup benMAPSetup = new BenMAPSetup()
{
SetupID = Convert.ToInt32(dr["SetupID"]),
SetupName = dr["SetupName"].ToString()
};
mnuActiveSetup.DropDownItems.Clear();
foreach (DataRow drSetup in ds.Tables[0].Rows)
{
BenMAPSetup benMAPSetupIn = new BenMAPSetup()
{
SetupID = Convert.ToInt32(drSetup["SetupID"]),
SetupName = drSetup["SetupName"].ToString()
};
ToolStripMenuItem toolStripMenuItem = new ToolStripMenuItem();
toolStripMenuItem.Text = drSetup["SetupName"].ToString();
toolStripMenuItem.Tag = benMAPSetupIn;
toolStripMenuItem.Click += new EventHandler(toolStripMenuItem_Click);
mnuActiveSetup.DropDownItems.Add(toolStripMenuItem);
}
if (mnuActiveSetup.DropDownItems.Count > 0)
{
mnuActiveSetup.Text = dr["SetupName"].ToString();
}
CommonClass.MainSetup = benMAPSetup;
CommonClass.ManageSetup = benMAPSetup;
CommonClass.lstPollutantAll = Grid.GridCommon.getAllPollutant(CommonClass.MainSetup.SetupID);
if (CommonClass.InputParams == null || CommonClass.InputParams.Length == 0)
{
StartPage startFrm = new StartPage();
startFrm.ShowDialog();
}
else if (CommonClass.InputParams[0].ToLower().Contains(".ctlx"))
{
this.Hide();
this.ShowInTaskbar = false;
this.WindowState = FormWindowState.Minimized;
return;
}
LoadForm(new BenMAP(sPicName));
InitRecentFile();
CommonClass.FormChangedStat -= SetCurrentStat;
CommonClass.FormChangedStat += SetCurrentStat;
CommonClass.FormChangedSetup -= SetCurrentSetup;
CommonClass.FormChangedSetup += SetCurrentSetup;
if (_currentForm != null)
{
BenMAP frm = _currentForm as BenMAP;
if (frm != null)
{
frm.OpenFile();
frm.loadInputParamProject();
}
frm.mainFrm = this;
}
this.Status = "Current Setup: " + CommonClass.MainSetup.SetupName;
lblStatus.Text = this.Status;
}
catch (Exception ex)
{
Logger.LogError(ex);
}
}
