public bool IsExistExpressBillCode(string strExpressBillCode, string strBillTypeCode)
{
DataOperate dataOper = new DataOperate();
try
{
//创建泛型
List <SqlParameter> parameters = new List <SqlParameter>();
//创建SqlParameter对象，并赋值
SqlParameter paramExpressBillCode = new SqlParameter("@ExpressBillCode", SqlDbType.VarChar);
paramExpressBillCode.Value = strExpressBillCode;
parameters.Add(paramExpressBillCode);
//---
SqlParameter paramBillTypeCode = new SqlParameter("@BillTypeCode", SqlDbType.VarChar);
paramBillTypeCode.Value = strBillTypeCode;
parameters.Add(paramBillTypeCode);
//把泛型中的元素复制到数组中
SqlParameter[] inputParameters = parameters.ToArray();
DataTable dt = dataOper.GetDataTable("IsExistExpressBillCode", inputParameters);
if (Convert.ToInt32(dt.Rows[0][0]) > 0)
{
return(true);
}
else
{
return(false);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "软件提示");
throw ex;
}
}
public JsonResult Login(UserLoginForm loginForm)
{
var sql = "select * from user where email=@Email and pwd=@Pwd";
var mySqlConnection = DataOperate.GetCon();
var cmd = new MySqlCommand(sql, mySqlConnection);
cmd.Parameters.Add(new MySqlParameter("Email", MySqlDbType.VarChar, 16));
cmd.Parameters["Email"].Value = loginForm.Email;
cmd.Parameters.Add(new MySqlParameter("Pwd", MySqlDbType.VarChar, 32));
cmd.Parameters["Pwd"].Value = loginForm.Pwd;
var user = DataOperate.FindOne(cmd);
if (user == null)
{
mySqlConnection.Close();
return(Fail("用户或密码输入有误，登录失败..", 1006));
}
HttpContext.Session.SetString("userEmail", loginForm.Email);
HttpContext.Session.SetString("userId", user["id"].ToString());
mySqlConnection.Close();
return(Success(user));
}
public JsonResult SelfDescTags()
{
string sql = "select * from user inner join selfDesc on user.id = selfDesc.selfId where user.id = " +
GetUserId();
return(Success(DataOperate.FindAll(sql)));
}
public JsonResult CreateHouseCommission(CreateHouseCommission createHouseCommission)
{
string sql =
"insert into house(atCity,community,address,area,floor,layout,orientation,buildAt,rentType,toilet,balcony,houseNum,roomNum,userId) " +
"values(@AtCity,@Community,@Address,@Area,@Floor,@Layout,@Orientation,@BuildAt,@RentType,@Toilet,@Balcony,@HouseNum,@RoomNum,@UserId)";
MySqlConnection con = DataOperate.GetCon();
MySqlCommand cmd = new MySqlCommand(sql, con);
cmd.Parameters.Add(new MySqlParameter("@AtCity", MySqlDbType.VarChar, 10)).Value = createHouseCommission.AtCity;
cmd.Parameters.Add(new MySqlParameter("@Community", MySqlDbType.VarChar, 10)).Value = createHouseCommission.Community;
cmd.Parameters.Add(new MySqlParameter("@Address", MySqlDbType.VarChar, 50)).Value = createHouseCommission.Address;
cmd.Parameters.Add(new MySqlParameter("@Area", MySqlDbType.Float)).Value = createHouseCommission.Area;
cmd.Parameters.Add(new MySqlParameter("@Floor", MySqlDbType.VarChar, 10)).Value = createHouseCommission.Floor;
cmd.Parameters.Add(new MySqlParameter("@Layout", MySqlDbType.VarChar, 10)).Value = createHouseCommission.Layout;
cmd.Parameters.Add(new MySqlParameter("@Orientation", MySqlDbType.VarChar, 10)).Value = createHouseCommission.Orientation;
cmd.Parameters.Add(new MySqlParameter("@BuildAt", MySqlDbType.Date)).Value = createHouseCommission.BuildAt;
cmd.Parameters.Add(new MySqlParameter("@RentType", MySqlDbType.Enum)).Value = createHouseCommission.RentType;
cmd.Parameters.Add(new MySqlParameter("@Toilet", MySqlDbType.Int32, 11)).Value = createHouseCommission.Toilet;
cmd.Parameters.Add(new MySqlParameter("@Balcony", MySqlDbType.Int32, 11)).Value = createHouseCommission.Balcony;
cmd.Parameters.Add(new MySqlParameter("@HouseNum", MySqlDbType.VarChar, 10)).Value = createHouseCommission.HouseNum;
cmd.Parameters.Add(new MySqlParameter("@RoomNum", MySqlDbType.VarChar, 10)).Value = createHouseCommission.RoomNum;
cmd.Parameters.Add(new MySqlParameter("@UserId", MySqlDbType.Int32, 11)).Value = GetUserId();
try
{
cmd.ExecuteNonQuery();
con.Close();
}
catch (System.Exception e)
{
con.Close();
return(Success(false));
}
return(Success(true));
}
public JsonResult RemoveCollect(RemoveCollect removeCollect)
{
string sql = "delete from houseCollected where houseId=" + removeCollect.HouseId + " and userId=" +
GetUserId();
return(Success(DataOperate.Update(sql)));
}
public JsonResult HandleOrder(OrderInfo orderInfo)
{
string sql = "insert into houseOrdered(houseId,userId,orderTime,orderPhone) values (" + orderInfo.HouseId +
", " + GetUserId() + ", '" + orderInfo.OrderTime + "', '" + orderInfo.OrderPhone + "')";
return(Success(DataOperate.Create(sql)));
}
public JsonResult GetHouseDetailInfo(int houseId)
{
bool liked;
var sqlExits = "select count(*) from houseCollected where houseId=" + houseId + " and userId=" +
GetUserId();
var count = Convert.ToInt32(DataOperate.Sele(sqlExits));
var sql = "select * from house inner join contract on house.id = contract.houseId where house.id=" +
houseId;
if (count == 0)
{
return(Success(new
{
self = DataOperate.FindAll(sql),
liked = false
}));
}
else
{
return(Success(new
{
self = DataOperate.FindAll(sql),
liked = true
}));
}
}
public JsonResult RejectOwnerRenewalApply(RejectOwnerRenewalApply rejectOwnerRenewalApply)
{
var sql = "update renewalContractApply set applyStatus='reject', adminId=" + GetAdminId() + " where id=" +
rejectOwnerRenewalApply.Id;
return(Success(DataOperate.Update(sql)));
}
private void tBtnStopTest_Click(object sender, EventArgs e)
{
// GlobalData.serialPort.TxdCommand(SerialPortControl.Command_Stop_Fire);
tmrAutoStopFire.Enabled = false;
GlobalData.serialPort.TxdCommand(0xF7);
DataOperate.MyTable.Rows[GlobalData.DataRowIndex]["实验结果"] = GlobalData.TimerCount.ToString("f1");
GlobalData.DataRowIndex++;
GlobalCofigData.SystemConfig.SerialNo++;
frmDebugInfo.StopTest();
GlobalData.SystemStatus = SystemStatuses.SystemReady;
//GlobalData.serialPort.TxdCommand(SerialPortControl.Command_Fall);
if (GlobalData.DataRowIndex > 10)
{
try
{
DataOperate.UpdateTestData();
menuOpenDatabase_Click(null, null);
NewTestData();
GlobalData.DataRowIndex = 0;
}
catch (Exception err)
{
GlobalData.frmStatus.WriteLog("tBtnStopTest_Click: " + err.Message, false);
}
}
}
public JsonResult RejectHouseOrder(RejectHouseOrder rejectHouseOrder)
{
var sql = "UPDATE houseOrdered SET orderStatus = 'reject', adminId = " + GetAdminId() +
" WHERE id = " + rejectHouseOrder.Id;
return(Success(DataOperate.Update(sql)));
}
/// <summary>
/// 获取延期申请列表
/// </summary>
/// <param name="qc"></param>
/// <returns></returns>
public Result <List <Epm_PlanDelay> > GetPlanDelayList(QueryCondition qc)
{
Result <List <Epm_PlanDelay> > result = new Result <List <Epm_PlanDelay> >();
try
{
AddDefaultWeb(qc);
qc.PageInfo = new PageListInfo();
if (!qc.SortList.Any())
{
qc.SortList.Add(new SortExpression()
{
SortName = "ProjectId",
SortType = eSortType.Desc
});
}
result = DataOperate.QueryListSimple <Epm_PlanDelay>(context, qc);
}
catch (Exception ex)
{
result.Data = null;
result.Flag = EResultFlag.Failure;
result.Exception = new ExceptionEx(ex, "");
result.AllRowsCount = -1;
}
return(result);
}
public bool DeleteOwnerToTenant(DeleteOwnerToTenant deleteOwnerToTenant)
{
var selSql = "select * from contract where userId=" + deleteOwnerToTenant.Id;
string[] sqlT = new string[2];
int i = 0;
sqlT[i++] = "update house set houseStatus = 'unactivated' where userId=" + deleteOwnerToTenant.Id;
sqlT[i] = "update user SET type = 'tenant' where id= " + deleteOwnerToTenant.Id;
DataSet allContract = DataOperate.FindAll(selSql);
if (allContract.Tables.Count == 1 && allContract.Tables[0].Rows.Count == 0)
{
DataOperate.Update(sqlT[i]);
return(true);
}
else if (GetContractBool(allContract))
{
return(DataOperate.ExecTransaction(sqlT));
}
else
{
return(false);
}
}
protected void xiugai_Click(object sender, EventArgs e)
{
if (txtPwd.Text.Length == 0)
{
Response.Write("<script lanuage=javascript>alert('密码不能为空！');</script>");
}
else
{
string textpwd = CJ_DBOperater.CJ.PwdSecurity(txtPwd.Text.Trim());
DataOperate dataopr = new DataOperate();
//string sql="update tb_User set UserPwd=" + textpwd.ToString() + " where UserName="******"UserName"].ToString();
string sql = string.Format("update tb_User set UserPwd='{0}' where UserName='******'", textpwd, Session["UserName"].ToString());
if (dataopr.DataCom(sql))
{
Session.Clear();
Response.Write("<script lanuage=javascript>alert('密码修改成功！'); location.href='../../../login.aspx' </script>");
}
else
{
Session.Clear();
Response.Write("<script lanuage=javascript>alert('密码修改失败！');location.href='../../../login.aspx'</script>");
}
}
}
public JsonResult SelfDescTags()
{
string sql = "select * from admin inner join selfDesc on admin.id = selfDesc.selfId where admin.id = " +
GetAdminId();
return(Success(DataOperate.FindAll(sql)));
}
private void 设置SToolStripMenuItem1_Click(object sender, EventArgs e)
{
FormSet frmSet = new FormSet();
frmSet.ShowDialog();
DataOperate.UpdateConfigureData(); //在此更新考虑取消某些数据
}
public JsonResult Register(AdminRegisterForm registerForm)
{
string MailCode = registerForm.Code;
string LicenseKey = registerForm.LicenseKey;
string str = HttpContext.Session.GetInt32("code").ToString();
if (str == MailCode && LicenseKey == "fox072065yat")
{
string sql = "insert into admin(email,pwd) values(@Email,@Pwd)";
MySqlConnection con = DataOperate.GetCon();
MySqlCommand com = new MySqlCommand(sql, con);
com = new MySqlCommand(sql, con);
com.Parameters.Add(new MySqlParameter("@Email", MySqlDbType.VarChar, 16));
com.Parameters["@Email"].Value = registerForm.Email;
com.Parameters.Add(new MySqlParameter("@Pwd", MySqlDbType.VarChar, 32));
com.Parameters["@Pwd"].Value = registerForm.Pwd;
if (com.ExecuteNonQuery() > 0)
{
con.Close();
return(Success("true"));
}
else
{
con.Close();
return(Fail("注册失败，请重试..", 1004));
}
}
else
{
return(Fail("验证码输入有误，请重试..", 1005));
}
}
protected void GridViewArticle_onRowCommand(object sender, GridViewCommandEventArgs e)
{
string sql1 = "update tb_User set UserMark=UserMark-0 where UserName='******'";
DataOperate dataoper = new DataOperate();
if (dataoper.DataCom(sql1))
{
Response.Write("<script language=javascript>alert('下载成功！');</script>");
}
string File = Convert.ToString(e.CommandArgument); //获取行号
string parentpath = HttpContext.Current.Server.MapPath("/Attach/");
string FullFileName = parentpath + File;
FileInfo DownloadFile = new FileInfo(FullFileName);
Response.Clear();
Response.ClearContent();
Response.ClearHeaders();
Response.Buffer = false;
Response.ContentType = "application/octet-stream";
Response.AppendHeader("Content-Disposition", "attachment;filename=" + File);
Response.AppendHeader("Content-Length", DownloadFile.Length.ToString());
Response.AddHeader("Content-Transfer-Encoding", "binary");
Response.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312");
Response.WriteFile(DownloadFile.FullName);
Response.Flush();
Response.End();
}
public void ProcessRequest(HttpContext context)
{
string file = context.Request.Params.Get("file");
//string File = Convert.ToString(e.CommandArgument); //获取行号
//string sql1 = "update tb_User set UserMark=UserMark-10 where UserName='******'";
DataOperate dataoper = new DataOperate();
string sql2 = "update DownAttach set count=count+1 where filesavename='" + file + "'";
DataOperate dataoper2 = new DataOperate();
if (dataoper2.DataCom(sql2))
{
context.Session["Mark"] = (Convert.ToInt32(context.Session["Mark"]) - 0).ToString();
}
string parentpath = HttpContext.Current.Server.MapPath("/Attach/");
string FullFileName = parentpath + file;
FileInfo DownloadFile = new FileInfo(FullFileName);
FullFileName = file;
context.Response.Clear();
context.Response.ClearContent();
context.Response.ClearHeaders();
context.Response.Buffer = false;
context.Response.ContentType = "application/octet-stream";
context.Response.AppendHeader("Content-Disposition", "attachment;filename=" + file);
context.Response.AppendHeader("Content-Length", DownloadFile.Length.ToString());
context.Response.AddHeader("Content-Transfer-Encoding", "binary");
context.Response.ContentEncoding = System.Text.Encoding.GetEncoding("UTF-8");
context.Response.WriteFile(DownloadFile.FullName);
context.Response.Flush();
context.Response.End();
}
/// <summary>
/// 记录日志
/// </summary>
/// <param name="operate"></param>
/// <param name="result"></param>
/// <param name="data"></param>
private static void OperateLog(DataOperate operate, string data)
{
if (string.IsNullOrEmpty(data))
{
return;
}
}
public JsonResult PassHouseOrder(PassHouseOrder passHouseOrder)
{
var sql = "UPDATE houseOrdered SET orderStatus = 'done', adminId = " + GetAdminId() +
" WHERE id = " + passHouseOrder.Id;
return(Success(DataOperate.Update(sql)));
}
public JsonResult GetHouseListToTable(GetHouseListToTable getHouseListToTable)
{
var selSql1 = "select * from house ";
DataSet allHouse = DataOperate.FindAll(selSql1);
string[] signed = { "activated", "empty" };
// 检查房主合同状态 修改房源状态
foreach (DataRow row in allHouse.Tables[0].Rows)
{
if (signed.Contains(row["rentStatus"].ToString()))
{
var selSql2 = "select * from contract where type='withOwner' and contractStatus = 'undue' and houseId=" + row["id"].ToString();
DataSet allHouseContract = DataOperate.FindAll(selSql2);
if (allHouseContract.Tables.Count == 1 && allHouseContract.Tables[0].Rows.Count == 0)
{
DataOperate.Update("update house set rentStatus='invalid' where id=" + row["id"]);
}
}
}
var countSql = "select count(*) from house";
var sql = "select * from house";
if (getHouseListToTable.Status.Length > 0)
{
countSql += " where rentStatus in ('" + string.Join("','", getHouseListToTable.Status) + "')";
sql += " where rentStatus in ('" + string.Join("','", getHouseListToTable.Status) + "')";
}
sql += " order by id desc limit " + (getHouseListToTable.PageNum - 1) * getHouseListToTable.PageSize + "," + getHouseListToTable.PageSize;
return(Success(new { totalCount = DataOperate.Sele(countSql), data = DataOperate.FindAll(sql) }));
}
private void toolDeleteCTextBox_Click(object sender, EventArgs e)
{
if (MessageBox.Show("确定要删除吗？", "软件提示", MessageBoxButtons.YesNo, MessageBoxIcon.Exclamation) == DialogResult.Yes)
{
if (ControlId != 0) //旧的控件
{
CommClass cc = new CommClass();
DataOperate dataOper = new DataOperate();
try
{
if (cc.IsExistConstraint("tb_BillTemplate", ControlId.ToString())) //对应的子表tb_BillText已生成外键数据，先删除外键记录
{
if (MessageBox.Show("该输入框已生成快递单数据，若继续执行将删除与之相关的数据，是否继续执行？", "软件提示", MessageBoxButtons.YesNo, MessageBoxIcon.Exclamation) == DialogResult.No)
{
return; //停止执行
}
}
if (dataOper.ExecDataBySql("Delete From tb_BillTemplate Where ControlId = '" + ControlId + "'") == 0) //从模板表中删除该控件对应的记录
{
MessageBox.Show("删除失败！", "软件提示");
return;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "软件提示");
return;
}
}
this.Dispose();
MessageBox.Show("删除成功！", "软件提示");
}
}
public JsonResult RejectHouseCommission(RejectHouseCommission rejectHouseCommission)
{
var sql = "UPDATE house SET rentStatus = 'reject', adminId = " + GetAdminId() +
" WHERE id = " + rejectHouseCommission.Id;
return(Success(DataOperate.Update(sql)));
}
public JsonResult PassHouseCommission(PassHouseCommission passHouseCommission)
{
var sql = "UPDATE house SET rentStatus = 'unactivated', adminId = " + GetAdminId() +
" WHERE id = " + passHouseCommission.Id;
return(Success(DataOperate.Update(sql)));
}
public JsonResult GetContractListOfAdmin()
{
string sql = "select * from contract inner join house on house.id = contract.houseId inner join admin on admin.id = contract.adminId where admin.id=" +
GetAdminId() + " order by startAt desc";
return(Success(DataOperate.FindAll(sql)));
}
private void 当天记录CToolStripMenuItem_Click(object sender, EventArgs e)
{
fg.FinishEditing(true);
string Database;
Database = Application.StartupPath + @"\DataBase\" + "SDAF" + DateTime.Now.Year.ToString() + ".mdb";
if (!File.Exists(Database))
{
return;
}
DataOperate.CurrentDataBase = DateTime.Now.Year;
CurDb.Text = Properties.Resources.CurrentDatabase + DataOperate.CurrentDataBase.ToString() + Properties.Resources.Year;
DataOperate.FindDayData();
for (int i = 0; i < 数据库ToolStripMenuItem.DropDownItems.Count; i++)
{
ToolStripMenuItem Chk_Tp = (ToolStripMenuItem)数据库ToolStripMenuItem.DropDownItems[i];
if ((int)Chk_Tp.Tag == DataOperate.CurrentDataBase)
{
Chk_Tp.Checked = true;
}
else
{
Chk_Tp.Checked = false;
}
}
}
public void connetion()//综合交流
{
DataOperate dataoper = new DataOperate();
string sqlconn = "select top 6 * from ModuleInfo_View where ModuleID=34 order by CardDate desc";
dataoper.dataBind(DatalistConn, sqlconn);
}
private void MyTable_RowChanged(object sender, DataRowChangeEventArgs e)
{
if (beModifed && e.Row.RowState == DataRowState.Modified)
{
beModifed = false;
DataOperate.UpdateTestData();
}
}
public JsonResult ApplyHouseRenewal(ApplyRenewal applyRenewal)
{
var sql = "insert into renewalContractApply(contractId,type,houseId,userId) values(" +
applyRenewal.ContractId + ",'" + applyRenewal.Type + "'," + applyRenewal.HouseId + "," +
GetUserId() + ")";
return(Success(DataOperate.Create(sql)));
}
public JsonResult GetHouseListOfAdmin()
{
string sql =
"select * from house inner join contract on house.id = contract.houseId where contract.type = 'withOwner' and contract.adminId=" +
GetAdminId();
return(Success(DataOperate.FindAll(sql)));
}