private void btSave_Click(object sender, System.EventArgs e)
{
string sSQL = "";
string sWhere = "";
string p2_Name = CCUtility.ToSQL(Utility.GetParam("tbName"), FieldTypes.Text);
string p2_Area = CCUtility.ToSQL(Utility.GetParam("tbArea"), FieldTypes.Text);
string p2_High = CCUtility.ToSQL(Utility.GetParam("tbHigh"), FieldTypes.Text);
string p2_Layer = CCUtility.ToSQL(Utility.GetParam("tbLayer"), FieldTypes.Text);
string p2_BuildDate = CCUtility.ToSQL(Utility.GetParam("tbBuildDate"), FieldTypes.Text);
string p2_Type = CCUtility.ToSQL(Utility.GetParam("ddlTYpe"), FieldTypes.Number);
string p2_Sunny = CCUtility.ToSQL(Utility.GetParam("ddlSunny"), FieldTypes.Number);
string p2_Memo = CCUtility.ToSQL(Utility.GetParam("tbMemo"), FieldTypes.Text);
if (tbName.Text.Trim() == "")
{
ShowErrMsg("请输入楼宇名称");
return;
}
if (p_theID.Value.Length == 0)
{
int iCount = Utility.DlookupInt("pavilion", "count(*)", "Name=" + CCUtility.ToSQL(Utility.GetParam("tbName"), FieldTypes.Text));
if (iCount != 0)
{
ShowErrMsg(sErrMsg);
return;
}
sSQL = "insert into Pavilion ( " +
"name," +
"Area," +
"High," +
"Layer," +
"BuildDate," +
"Memo," +
"sunnyID," +
"typeID) " +
" values(" +
p2_Name + "," +
p2_Area + "," +
p2_High + "," +
p2_Layer + "," +
p2_BuildDate + "," +
p2_Memo + "," +
p2_Sunny + "," +
p2_Type + ")";
}
else
{
sWhere = " paID=" + CCUtility.ToSQL(p_theID.Value, FieldTypes.Number);
int iCount = Utility.DlookupInt("pavilion", "count(*)", "Name=" + CCUtility.ToSQL(Utility.GetParam("tbName"), FieldTypes.Text) + " and not(" + sWhere + ")");
if (iCount != 0)
{
ShowErrMsg(sErrMsg);
return;
}
sSQL = " update Pavilion set " +
"[Name]=" + p2_Name +
",[Area]=" + p2_Area +
",[High]=" + p2_High +
",[Layer]=" + p2_Layer +
",[BuildDate]=" + p2_BuildDate +
",[Memo]=" + p2_Memo +
",[typeID]=" + p2_Type +
",[sunnyID]=" + p2_Sunny;
sSQL += " where " + sWhere;
}
SqlCommand cmd = new SqlCommand(sSQL, Utility.Connection);
try
{
cmd.ExecuteNonQuery();
}
catch (Exception E)
{
ShowErrMsg(E.Message);
return;
}
Response.Redirect(sFormAction);
}
private void btSave_Click(object sender, System.EventArgs e)
{
string sSQL = "";
// EditMeter Check Event begin
bool bResult = EditMeter_Validate();
// EditMeter Check Event end
if (!bResult)
{
return;
}
string p2_Pavilion = CCUtility.ToSQL(paID.Value, FieldTypes.Number);
string p2_House = CCUtility.ToSQL(Utility.GetParam("ddl_House"), FieldTypes.Number);
string p2_Phone = CCUtility.ToSQL(Utility.GetParam("tbPhone"), FieldTypes.Text);
string p2_Memo = CCUtility.ToSQL(Utility.GetParam("tb_Memo"), FieldTypes.Text);
if (tbPhone.Text == "")
{
ShowErrMsg("请输入电话号码");
return;
}
if (p_theID.Value.Length == 0)
{
sSQL = "phone=" + p2_Phone;
int iCount = Utility.DlookupInt("Phone", "count(*)", sSQL);
if (iCount != 0)
{
ShowErrMsg("该电话已经存在!");
return;
}
sSQL = "insert into Phone (" +
"paID," +
"hoID," +
"phone," +
"Memo)" +
" values (" +
p2_Pavilion + "," +
p2_House + "," +
p2_Phone + "," +
p2_Memo + ")";
}
else
{
string sExist;
sExist = "phone=" + p2_Phone + " and id<>" + CCUtility.ToSQL(p_theID.Value, FieldTypes.Number);
int iCount = Utility.DlookupInt("Phone", "count(*)", sExist);
if (iCount != 0)
{
ShowErrMsg("该电话已经存在!");
return;
}
string sWhere = "ID=" + CCUtility.ToSQL(p_theID.Value, FieldTypes.Number);
sSQL = "update Phone set" +
"[paID]=" + p2_Pavilion +
",[hoID]=" + p2_House +
",[phone]=" + p2_Phone +
",[Memo]=" + p2_Memo;
sSQL = sSQL + " where " + sWhere;
}
SqlCommand cmd = new SqlCommand(sSQL, Utility.Connection);
try
{
cmd.ExecuteNonQuery();
}
catch (Exception E)
{
theValidationSummary.Text += E.Message;
theValidationSummary.Visible = true;
return;
}
Back();
}
private void btSave_Click(object sender, System.EventArgs e)
{
string sSQL = "";
string sWhere = "", sExist;
string p2_Login = CCUtility.ToSQL(Utility.GetParam("tbLogin"), FieldTypes.Text);
string p2_PassWord = CCUtility.ToSQL(Utility.GetParam("tbPassWord"), FieldTypes.Text);
string p2_Name = CCUtility.ToSQL(Utility.GetParam("tbName"), FieldTypes.Text);
string p2_Level = CCUtility.ToSQL(Utility.GetParam("ddl_Level"), FieldTypes.Number);
string p2_Memo = CCUtility.ToSQL(Utility.GetParam("tbMemo"), FieldTypes.Text);
if (tbLogin.Text.Trim() == "")
{
ShowErrMsg("请输入登陆名.");
return;
}
if (p_theID.Value.Length == 0) //插入查询
{
sExist = "member_login="******"tbLogin"), FieldTypes.Text);
int iCount = Utility.DlookupInt("Members", "count(*)", sExist);
if (iCount != 0)
{
ShowErrMsg(sErrMsg);
return;
}
sSQL = "insert into Members ( " +
"name," +
"member_login," +
"member_password," +
"security_level_id," +
"Memo) " +
" values(" +
p2_Name + "," +
p2_Login + "," +
p2_PassWord + "," +
p2_Level + "," +
p2_Memo + ")";
}
else
{
//查看车位是否已经存在
sExist = "member_login="******"tbLogin"), FieldTypes.Text) +
" and member_id<>" + CCUtility.ToSQL(p_theID.Value, FieldTypes.Number);
int iCount = Utility.DlookupInt("Members", "count(*)", sExist);
if (iCount != 0)
{
ShowErrMsg(sErrMsg);
return;
}
sWhere = " member_id=" + CCUtility.ToSQL(p_theID.Value, FieldTypes.Number);
sSQL = " update members set " +
"[name]=" + p2_Name +
",[member_login]=" + p2_Login +
",[member_password]=" + p2_PassWord +
",[security_level_id]=" + p2_Level +
",[Memo]=" + p2_Memo;
sSQL += " where " + sWhere;
}
SqlCommand cmd = new SqlCommand(sSQL, Utility.Connection);
try
{
cmd.ExecuteNonQuery();
}
catch (Exception E)
{
ShowErrMsg(E.Message);
return;
}
Back(); //Response.Redirect(sFormAction);
}
private void btSave_Click(object sender, System.EventArgs e)
{
string sSQL = "";
string sWhere = "", sExist;
string p2_NO = CCUtility.ToSQL(Utility.GetParam("tbNO"), FieldTypes.Text);
string p2_CarNO = CCUtility.ToSQL(Utility.GetParam("tbCarNO"), FieldTypes.Text);
string p2_Type = CCUtility.ToSQL(Utility.GetParam("tbType"), FieldTypes.Text);
string p2_Area = CCUtility.ToSQL(Utility.GetParam("tbArea"), FieldTypes.Text);
string p2_Place = CCUtility.ToSQL(Utility.GetParam("tbPlace"), FieldTypes.Text);
string p2_Master = CCUtility.ToSQL(Utility.GetParam("tbMaster"), FieldTypes.Text);
string p2_Memo = CCUtility.ToSQL(Utility.GetParam("tbMemo"), FieldTypes.Text);
if (tbNO.Text.Trim() == "")
{
ShowErrMsg("请输入车位号.");
return;
}
if (p_theID.Value.Length == 0) //插入查询
{
sExist = "theNO=" + CCUtility.ToSQL(Utility.GetParam("tbNO"), FieldTypes.Text);
int iCount = Utility.DlookupInt("CarBarn", "count(*)", sExist);
if (iCount != 0)
{
ShowErrMsg(sErrMsg);
return;
}
sSQL = "insert into Carbarn ( " +
"theNO," +
"carNO," +
"carType," +
"Area," +
"Place," +
"Master," +
"Memo) " +
" values(" +
p2_NO + "," +
p2_CarNO + "," +
p2_Type + "," +
p2_Area + "," +
p2_Place + "," +
p2_Master + "," +
p2_Memo + ")";
}
else
{
//查看车位是否已经存在
sExist = "theNO=" + CCUtility.ToSQL(Utility.GetParam("tbNO"), FieldTypes.Text) +
" and ID<>" + CCUtility.ToSQL(p_theID.Value, FieldTypes.Number);
int iCount = Utility.DlookupInt("Carbarn", "count(*)", sExist);
if (iCount != 0)
{
ShowErrMsg(sErrMsg);
return;
}
sWhere = " ID=" + CCUtility.ToSQL(p_theID.Value, FieldTypes.Number);
sSQL = " update carbarn set " +
"[theNO]=" + p2_NO +
",[carNO]=" + p2_CarNO +
",[carType]=" + p2_Type +
",[Area]=" + p2_Area +
",[Place]=" + p2_Place +
",[Master]=" + p2_Master +
",[Memo]=" + p2_Memo;
sSQL += " where " + sWhere;
}
SqlCommand cmd = new SqlCommand(sSQL, Utility.Connection);
try
{
cmd.ExecuteNonQuery();
}
catch (Exception E)
{
ShowErrMsg(E.Message);
return;
}
Back(); //Response.Redirect(sFormAction);
}
private void btSave_Click(object sender, System.EventArgs e)
{
string sSQL = "";
string sWhere = "", sExist;
string p2_paID = CCUtility.ToSQL(paID.Value, FieldTypes.Number);
string p2_Room = CCUtility.ToSQL(Utility.GetParam("tbRoom"), FieldTypes.Text);
string p2_Area = CCUtility.ToSQL(Utility.GetParam("tbArea"), FieldTypes.Text);
string p2_Area2 = CCUtility.ToSQL(Utility.GetParam("tbArea2"), FieldTypes.Text);
string p2_Layer = CCUtility.ToSQL(Utility.GetParam("tbLayer"), FieldTypes.Text);
string p2_Cell = CCUtility.ToSQL(Utility.GetParam("ddlCell"), FieldTypes.Number);
string p2_Type = CCUtility.ToSQL(Utility.GetParam("ddlTYpe"), FieldTypes.Number);
string p2_Sunny = CCUtility.ToSQL(Utility.GetParam("ddlSunny"), FieldTypes.Number);
string p2_Memo = CCUtility.ToSQL(Utility.GetParam("tbMemo"), FieldTypes.Text);
string p2_ClientName = CCUtility.ToSQL(Utility.GetParam("tbClientName"), FieldTypes.Text);
string p2_ClientID = CCUtility.ToSQL(Utility.GetParam("tbClientID"), FieldTypes.Text);
string p2_UseDate = CCUtility.ToSQL(Utility.GetParam("tbUseDate"), FieldTypes.Text);
string p2_Phone = CCUtility.ToSQL(Utility.GetParam("tbPhone"), FieldTypes.Text);
string p2_ClientCard = CCUtility.ToSQL(Utility.GetParam("tbClientCard"), FieldTypes.Text);
string p2_Unit = CCUtility.ToSQL(Utility.GetParam("tbUnit"), FieldTypes.Text);
if (tbRoom.Text.Trim() == "")
{
ShowErrMsg("请输入房间名称");
return;
}
if (tbPaName.Text.Trim() == "")
{
ShowErrMsg("请输入楼宇名称");
return;
}
if (p_theID.Value.Length == 0) //插入查询
{
sExist = "hoRoom=" + CCUtility.ToSQL(Utility.GetParam("tbRoom"), FieldTypes.Text) +
" and paID<>" + p2_paID;
int iCount = Utility.DlookupInt("House", "count(*)", sExist);
if (iCount != 0)
{
ShowErrMsg(sErrMsg);
return;
}
sSQL = "insert into House ( " +
"paID," +
"hoRoom," +
"hoFloor," +
"hoArchArce," +
"hoUseArce," +
"cellID," +
"sunnyId," +
"indoorID," +
"Memo," +
"CLIENT_NAME," +
"CLIENT_CARD," +
"CLIENT_ACCOUNT_NUMBER," +
"COMPANY_NAME," +
"CLIENT_PHONE," +
"USE_DATE) " +
" values(" +
p2_paID + "," +
p2_Room + "," +
p2_Layer + "," +
p2_Area + "," +
p2_Area2 + "," +
p2_Cell + "," +
p2_Sunny + "," +
p2_Type + "," +
p2_Memo + "," +
p2_ClientName + "," +
p2_ClientID + "," +
p2_ClientCard + "," +
p2_Unit + "," +
p2_Phone + "," +
p2_UseDate + ")";
}
else
{
//查看房间是否已经存在A
sExist = "hoRoom=" + CCUtility.ToSQL(Utility.GetParam("tbRoom"), FieldTypes.Text) +
" and paID<>" + p2_paID +
" and hoID<>" + CCUtility.ToSQL(p_theID.Value, FieldTypes.Number);
int iCount = Utility.DlookupInt("House", "count(*)", sExist);
if (iCount != 0)
{
ShowErrMsg(sErrMsg);
return;
}
sWhere = " hoID=" + CCUtility.ToSQL(p_theID.Value, FieldTypes.Number);
sSQL = " update House set " +
"[hoRoom]=" + p2_Room +
",[hoFloor]=" + p2_Layer +
",[hoArchArce]=" + p2_Area +
",[hoUseArce]=" + p2_Area2 +
",[cellID]=" + p2_Cell +
",[sunnyId]=" + p2_Sunny +
",[IndoorID]=" + p2_Type +
",[Memo]=" + p2_Memo +
",[Client_Name]=" + p2_ClientName +
",[CLIENT_CARD]=" + p2_ClientID +
",[CLIENT_ACCOUNT_NUMBER]=" + p2_ClientCard +
",[COMPANY_NAME]=" + p2_Unit +
",[CLIENT_PHONE]=" + p2_Phone +
",[USE_DATE]=" + p2_UseDate;
sSQL += " where " + sWhere;
}
SqlCommand cmd = new SqlCommand(sSQL, Utility.Connection);
try
{
cmd.ExecuteNonQuery();
}
catch (Exception E)
{
ShowErrMsg(E.Message);
return;
}
Back();//Response.Redirect(sFormAction);
}
