/// <summary>
/// 得到最大ID
/// </summary>
public int GetMaxId()
{
return(DbHelperMySQL.GetMaxID("id", "t_unit_goods"));
}
/// <summary>
/// 得到最大ID
/// </summary>
public int GetMaxId()
{
return(DbHelperMySQL.GetMaxID("Id", "blogcommentarticle"));
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Jium.Model.servicerorder model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update servicerorder set ");
strSql.Append("ccode=@ccode,");
strSql.Append("spid=@spid,");
strSql.Append("spnum=@spnum,");
strSql.Append("spspan=@spspan,");
strSql.Append("sostatus=@sostatus,");
strSql.Append("createtime=@createtime,");
strSql.Append("updatetime=@updatetime,");
strSql.Append("updateby=@updateby,");
strSql.Append("sos1=@sos1,");
strSql.Append("sos2=@sos2,");
strSql.Append("sos3=@sos3,");
strSql.Append("sos4=@sos4,");
strSql.Append("sos5=@sos5,");
strSql.Append("sod1=@sod1,");
strSql.Append("sod2=@sod2,");
strSql.Append("sod3=@sod3,");
strSql.Append("sod4=@sod4,");
strSql.Append("sod5=@sod5");
strSql.Append(" where id=@id");
MySqlParameter[] parameters =
{
new MySqlParameter("@ccode", MySqlDbType.VarChar, 40),
new MySqlParameter("@spid", MySqlDbType.VarChar, 20),
new MySqlParameter("@spnum", MySqlDbType.Int32, 11),
new MySqlParameter("@spspan", MySqlDbType.Int32, 11),
new MySqlParameter("@sostatus", MySqlDbType.Int32, 11),
new MySqlParameter("@createtime", MySqlDbType.VarChar, 20),
new MySqlParameter("@updatetime", MySqlDbType.VarChar, 20),
new MySqlParameter("@updateby", MySqlDbType.VarChar, 40),
new MySqlParameter("@sos1", MySqlDbType.VarChar, 40),
new MySqlParameter("@sos2", MySqlDbType.VarChar, 40),
new MySqlParameter("@sos3", MySqlDbType.VarChar, 40),
new MySqlParameter("@sos4", MySqlDbType.VarChar, 40),
new MySqlParameter("@sos5", MySqlDbType.VarChar, 40),
new MySqlParameter("@sod1", MySqlDbType.Int32, 11),
new MySqlParameter("@sod2", MySqlDbType.Int32, 11),
new MySqlParameter("@sod3", MySqlDbType.Int32, 11),
new MySqlParameter("@sod4", MySqlDbType.Int32, 11),
new MySqlParameter("@sod5", MySqlDbType.Int32, 11),
new MySqlParameter("@id", MySqlDbType.Int64, 20)
};
parameters[0].Value = model.ccode;
parameters[1].Value = model.spid;
parameters[2].Value = model.spnum;
parameters[3].Value = model.spspan;
parameters[4].Value = model.sostatus;
parameters[5].Value = model.createtime;
parameters[6].Value = model.updatetime;
parameters[7].Value = model.updateby;
parameters[8].Value = model.sos1;
parameters[9].Value = model.sos2;
parameters[10].Value = model.sos3;
parameters[11].Value = model.sos4;
parameters[12].Value = model.sos5;
parameters[13].Value = model.sod1;
parameters[14].Value = model.sod2;
parameters[15].Value = model.sod3;
parameters[16].Value = model.sod4;
parameters[17].Value = model.sod5;
parameters[18].Value = model.id;
int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到最大ID
/// </summary>
public int GetMaxId()
{
return(DbHelperMySQL.GetMaxID("Id", "crm_set_pubpri"));
}
/// <summary>
/// 检测生成众生争霸排行榜
/// </summary>
/// <param name="now"></param>
private bool CheckBuildZhengBaRank(int selectRoleIfNewCreate, int nowMonth)
{
bool bMonthFirst = false;
try
{
DbHelperMySQL.ExecuteSql(
string.Format("INSERT IGNORE INTO t_async(`id`,`value`) VALUES({0},{1});",
AsyncTypes.ZhengBaCurrMonth, ZhengBaConsts.DefaultAsyncMonth)
);
// 防止人为的重新reload月排行榜导致众神争霸战斗信息丢失
/* 这里有一些细节要注意：
* 1：每月1号凌晨3点更新月排行榜，然后触发更新争霸角色
* 2: 服务器启动的时候，尝试生成争霸角色
* 3：要防止当月的争霸角色重复生成
* 4：必须保证天梯排行角色已经生成，才能生成争霸角色 -->例如，1号凌晨两点启动，必须保证等到3点的时候，天梯月排行榜生成之后，能够生成本月的争霸角色
*/
int oldMonth = (int)DbHelperMySQL.GetSingle("select value from t_async where id = " + AsyncTypes.ZhengBaCurrMonth);
object ageObj_tiantiMonth = DbHelperMySQL.GetSingle("select value from t_async where id = " + AsyncTypes.TianTiPaiHangModifyOffsetDay);
if (oldMonth != nowMonth &&
ageObj_tiantiMonth != null &&
ZhengBaUtils.MakeMonth(DataHelper2.GetRealDate((int)ageObj_tiantiMonth)) == nowMonth)
{
string strSql = string.Format("SELECT rid,rname,zoneid,duanweiid,duanweijifen,duanweirank,zhanli,data1,data2 FROM t_tianti_month_paihang ORDER BY duanweirank ASC LIMIT {0};", selectRoleIfNewCreate);
var sdr = DbHelperMySQL.ExecuteReader(strSql);
while (sdr != null && sdr.Read())
{
ZhengBaRoleInfoData roleData = new ZhengBaRoleInfoData();
roleData.RoleId = (int)Convert.ToInt32(sdr["rid"]);
roleData.ZoneId = (int)Convert.ToInt32(sdr["zoneid"]);
roleData.DuanWeiId = (int)Convert.ToInt32(sdr["duanweiid"]);
roleData.DuanWeiJiFen = (int)Convert.ToInt32(sdr["duanweijifen"]);
roleData.DuanWeiRank = (int)Convert.ToInt32(sdr["duanweirank"]);
roleData.ZhanLi = (int)Convert.ToInt32(sdr["zhanli"]);
roleData.RoleName = sdr["rname"].ToString();
if (!sdr.IsDBNull(sdr.GetOrdinal("data1")))
{
roleData.TianTiPaiHangRoleData = (byte[])(sdr["data1"]);
}
if (!sdr.IsDBNull(sdr.GetOrdinal("data2")))
{
roleData.PlayerJingJiMirrorData = (byte[])(sdr["data2"]);
}
if (string.IsNullOrEmpty(roleData.RoleName) && roleData.TianTiPaiHangRoleData != null)
{
var onlyName = DataHelper2.BytesToObject <TianTiPaiHangRoleData_OnlyName>(
roleData.TianTiPaiHangRoleData, 0, roleData.TianTiPaiHangRoleData.Length);
if (onlyName != null)
{
roleData.RoleName = onlyName.RoleName;
}
}
string repSql = string.Format(
"REPLACE INTO t_zhengba_roles(`month`,rid,zoneid,duanweiid,duanweijifen,duanweirank,zhanli,`grade`,`group`,state,rname,data1,data2) "
+ "VALUES({0},{1},{2},{3},{4},{5},{6},{7},{8},{9},'{10}',@content,@mirror)",
nowMonth, roleData.RoleId, roleData.ZoneId, roleData.DuanWeiId,
roleData.DuanWeiJiFen, roleData.DuanWeiRank, roleData.ZhanLi,
(int)EZhengBaGrade.Grade100, (int)ZhengBaConsts.NoneGroup, (int)EZhengBaState.None, roleData.RoleName);
DbHelperMySQL.ExecuteSqlInsertImg(repSql,
new List <Tuple <string, byte[]> > {
new Tuple <string, byte[]>("content", roleData.TianTiPaiHangRoleData),
new Tuple <string, byte[]>("mirror", roleData.PlayerJingJiMirrorData)
});
}
if (sdr != null)
{
sdr.Close();
}
DbHelperMySQL.ExecuteSql(
string.Format("REPLACE INTO t_async(`id`,`value`) VALUES({0},{1});",
AsyncTypes.ZhengBaCurrMonth, nowMonth)
);
bMonthFirst = true;
}
}
catch (Exception ex)
{
LogManager.WriteExceptionUseCache(ex.ToString());
}
return(bMonthFirst);
}
/// <summary>
/// 根据字段列表，条件，排序，读取记录
/// </summary>
/// <param name="columslist">字段列表，如：Id,姓名,性别,年龄</param>
/// <param name="strWhere">条件，如：年龄>12 and 性别='女'</param>
/// <param name="filedOrder">排序，如： Id desc </param>
/// <returns>返回组装好的json字符串</returns>
public string GetListByColumns_tojson(string columslist, string strWhere, string orderby)
{
string str = DbHelperMySQL.GetListByColumns_tojson(columslist, strWhere, orderby, "tb_navigation");
return(str);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Maticsoft.Model.ps_outfall model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update ps_outfall set ");
strSql.Append("Prj_No=@Prj_No,");
strSql.Append("Prj_Name=@Prj_Name,");
strSql.Append("MapCode=@MapCode,");
strSql.Append("SewageSystem_ID=@SewageSystem_ID,");
strSql.Append("StormSystem_ID=@StormSystem_ID,");
strSql.Append("Type=@Type,");
strSql.Append("X=@X,");
strSql.Append("Y=@Y,");
strSql.Append("High=@High,");
strSql.Append("Bottom_Elev=@Bottom_Elev,");
strSql.Append("OutfallShape=@OutfallShape,");
strSql.Append("OutfallType=@OutfallType,");
strSql.Append("Offset=@Offset,");
strSql.Append("Rotation=@Rotation,");
strSql.Append("Code=@Code,");
strSql.Append("Flap=@Flap,");
strSql.Append("Flap_Diameter=@Flap_Diameter,");
strSql.Append("Flap_TopEle=@Flap_TopEle,");
strSql.Append("Flap_BotEle=@Flap_BotEle,");
strSql.Append("Flap_Materail=@Flap_Materail,");
strSql.Append("Receive=@Receive,");
strSql.Append("Address=@Address,");
strSql.Append("PointPosition=@PointPosition,");
strSql.Append("DataSource=@DataSource,");
strSql.Append("Visibility=@Visibility,");
strSql.Append("Sunit=@Sunit,");
strSql.Append("Sdate=@Sdate,");
strSql.Append("UpdateTime=@UpdateTime,");
strSql.Append("Mdate=@Mdate,");
strSql.Append("Outfall_Type=@Outfall_Type,");
strSql.Append("Status=@Status,");
strSql.Append("Ename=@Ename,");
strSql.Append("Design_Dept=@Design_Dept,");
strSql.Append("Conster_Dept=@Conster_Dept,");
strSql.Append("Belong=@Belong,");
strSql.Append("Operator=@Operator,");
strSql.Append("Note=@Note,");
strSql.Append("Exp_NoOri=@Exp_NoOri,");
strSql.Append("FileName=@FileName,");
strSql.Append("Uploadtime=@Uploadtime");
strSql.Append(" where Exp_No=@Exp_No ");
MySqlParameter[] parameters =
{
new MySqlParameter("@Prj_No", MySqlDbType.VarChar, 255),
new MySqlParameter("@Prj_Name", MySqlDbType.VarChar, 255),
new MySqlParameter("@MapCode", MySqlDbType.VarChar, 10),
new MySqlParameter("@SewageSystem_ID", MySqlDbType.VarChar, 50),
new MySqlParameter("@StormSystem_ID", MySqlDbType.VarChar, 50),
new MySqlParameter("@Type", MySqlDbType.VarChar, 4),
new MySqlParameter("@X", MySqlDbType.Decimal, 10),
new MySqlParameter("@Y", MySqlDbType.Decimal, 10),
new MySqlParameter("@High", MySqlDbType.Decimal, 10),
new MySqlParameter("@Bottom_Elev", MySqlDbType.Decimal, 7),
new MySqlParameter("@OutfallShape", MySqlDbType.VarChar, 50),
new MySqlParameter("@OutfallType", MySqlDbType.VarChar, 10),
new MySqlParameter("@Offset", MySqlDbType.VarChar, 50),
new MySqlParameter("@Rotation", MySqlDbType.Decimal, 7),
new MySqlParameter("@Code", MySqlDbType.VarChar, 10),
new MySqlParameter("@Flap", MySqlDbType.VarChar, 10),
new MySqlParameter("@Flap_Diameter", MySqlDbType.Decimal, 7),
new MySqlParameter("@Flap_TopEle", MySqlDbType.Decimal, 7),
new MySqlParameter("@Flap_BotEle", MySqlDbType.Decimal, 7),
new MySqlParameter("@Flap_Materail", MySqlDbType.VarChar, 50),
new MySqlParameter("@Receive", MySqlDbType.VarChar, 50),
new MySqlParameter("@Address", MySqlDbType.VarChar, 100),
new MySqlParameter("@PointPosition", MySqlDbType.Int32, 10),
new MySqlParameter("@DataSource", MySqlDbType.VarChar, 10),
new MySqlParameter("@Visibility", MySqlDbType.VarChar, 4),
new MySqlParameter("@Sunit", MySqlDbType.VarChar, 255),
new MySqlParameter("@Sdate", MySqlDbType.VarChar, 255),
new MySqlParameter("@UpdateTime", MySqlDbType.VarChar, 255),
new MySqlParameter("@Mdate", MySqlDbType.VarChar, 255),
new MySqlParameter("@Outfall_Type", MySqlDbType.VarChar, 10),
new MySqlParameter("@Status", MySqlDbType.VarChar, 10),
new MySqlParameter("@Ename", MySqlDbType.VarChar, 100),
new MySqlParameter("@Design_Dept", MySqlDbType.VarChar, 255),
new MySqlParameter("@Conster_Dept", MySqlDbType.VarChar, 255),
new MySqlParameter("@Belong", MySqlDbType.VarChar, 255),
new MySqlParameter("@Operator", MySqlDbType.VarChar, 255),
new MySqlParameter("@Note", MySqlDbType.VarChar, 255),
new MySqlParameter("@Exp_NoOri", MySqlDbType.VarChar, 255),
new MySqlParameter("@FileName", MySqlDbType.VarChar, 255),
new MySqlParameter("@Uploadtime", MySqlDbType.VarChar, 255),
new MySqlParameter("@Exp_No", MySqlDbType.VarChar, 100)
};
parameters[0].Value = model.Prj_No;
parameters[1].Value = model.Prj_Name;
parameters[2].Value = model.MapCode;
parameters[3].Value = model.SewageSystem_ID;
parameters[4].Value = model.StormSystem_ID;
parameters[5].Value = model.Type;
parameters[6].Value = model.X;
parameters[7].Value = model.Y;
parameters[8].Value = model.High;
parameters[9].Value = model.Bottom_Elev;
parameters[10].Value = model.OutfallShape;
parameters[11].Value = model.OutfallType;
parameters[12].Value = model.Offset;
parameters[13].Value = model.Rotation;
parameters[14].Value = model.Code;
parameters[15].Value = model.Flap;
parameters[16].Value = model.Flap_Diameter;
parameters[17].Value = model.Flap_TopEle;
parameters[18].Value = model.Flap_BotEle;
parameters[19].Value = model.Flap_Materail;
parameters[20].Value = model.Receive;
parameters[21].Value = model.Address;
parameters[22].Value = model.PointPosition;
parameters[23].Value = model.DataSource;
parameters[24].Value = model.Visibility;
parameters[25].Value = model.Sunit;
parameters[26].Value = model.Sdate;
parameters[27].Value = model.UpdateTime;
parameters[28].Value = model.Mdate;
parameters[29].Value = model.Outfall_Type;
parameters[30].Value = model.Status;
parameters[31].Value = model.Ename;
parameters[32].Value = model.Design_Dept;
parameters[33].Value = model.Conster_Dept;
parameters[34].Value = model.Belong;
parameters[35].Value = model.Operator;
parameters[36].Value = model.Note;
parameters[37].Value = model.Exp_NoOri;
parameters[38].Value = model.FileName;
parameters[39].Value = model.Uploadtime;
parameters[40].Value = model.Exp_No;
int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Adds(XHD.Model.scm_authority_dtcolumn model)
{
List <string> strSqlList = new List <string>();
string[] menu_ids = model.Menu_ids.Split(',');
string[] column_ids;
string strSql = string.Empty;
string ids = model.column_ids.Replace(",", "");
if (!string.IsNullOrEmpty(ids))
{
foreach (var item in menu_ids)
{
if (!string.IsNullOrEmpty(item))
{
//查询该页面下的列
DataSet ds = GetListColumn("Menu_id='" + item + "'");
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
string columnIds = model.column_ids.Substring(2, model.column_ids.Length - 3);
if (columnIds.Length > 2)
{
string s = string.Empty;
column_ids = columnIds.Split(',');
foreach (var items in column_ids)
{
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
int column_id = Convert.ToInt32(ds.Tables[0].Rows[i]["column_id"].ToString());
if (column_id == Convert.ToInt32(items))
{
s += items + ",";
break;
}
}
}
strSql = string.Format(@"insert into scm_authority_dtcolumn (factory_Id,suppliers_id,Menu_ids,column_ids,Create_id,Create_date)
values('{0}','{1}','{2}','{3}','{4}','{5}')", model.factory_Id, model.suppliers_id, item, s, model.Create_id, model.Create_date);
strSqlList.Add(strSql);
}
else
{
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
int column_id = Convert.ToInt32(ds.Tables[0].Rows[i]["column_id"].ToString());
if (column_id == Convert.ToInt32(columnIds))
{
strSql = string.Format(@"insert into scm_authority_dtcolumn (factory_Id,suppliers_id,Menu_ids,column_ids,Create_id,Create_date)
values('{0}','{1}','{2}','{3}','{4}','{5}')", model.factory_Id, model.suppliers_id, item, columnIds, model.Create_id, model.Create_date);
strSqlList.Add(strSql);
}
}
}
}
}
}
}
int rows = DbHelperMySQL.ExecuteSqlTran(strSqlList);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Maticsoft.Model.ps_retention model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update ps_retention set ");
strSql.Append("Prj_No=@Prj_No,");
strSql.Append("Prj_Name=@Prj_Name,");
strSql.Append("MapCode=@MapCode,");
strSql.Append("Name=@Name,");
strSql.Append("SewageSystem_ID=@SewageSystem_ID,");
strSql.Append("StormSystem_ID=@StormSystem_ID,");
strSql.Append("Type=@Type,");
strSql.Append("X=@X,");
strSql.Append("Y=@Y,");
strSql.Append("High=@High,");
strSql.Append("Inflow_Type=@Inflow_Type,");
strSql.Append("Outflow_Type=@Outflow_Type,");
strSql.Append("Total_Vol=@Total_Vol,");
strSql.Append("B_Level=@B_Level,");
strSql.Append("Max_Level=@Max_Level,");
strSql.Append("Min_Level=@Min_Level,");
strSql.Append("Design_Time=@Design_Time,");
strSql.Append("Ps_Num=@Ps_Num,");
strSql.Append("FlowDir=@FlowDir,");
strSql.Append("Code=@Code,");
strSql.Append("Address=@Address,");
strSql.Append("DataSource=@DataSource,");
strSql.Append("Sunit=@Sunit,");
strSql.Append("Sdate=@Sdate,");
strSql.Append("UpdateTime=@UpdateTime,");
strSql.Append("Mdate=@Mdate,");
strSql.Append("DataListID=@DataListID,");
strSql.Append("Status=@Status,");
strSql.Append("Ename=@Ename,");
strSql.Append("Design_Dept=@Design_Dept,");
strSql.Append("Conster_Dept=@Conster_Dept,");
strSql.Append("Belong=@Belong,");
strSql.Append("Operator=@Operator,");
strSql.Append("Note=@Note,");
strSql.Append("Exp_NoOri=@Exp_NoOri,");
strSql.Append("FileName=@FileName,");
strSql.Append("Uploadtime=@Uploadtime");
strSql.Append(" where Exp_No=@Exp_No ");
MySqlParameter[] parameters =
{
new MySqlParameter("@Prj_No", MySqlDbType.VarChar, 10),
new MySqlParameter("@Prj_Name", MySqlDbType.VarChar, 100),
new MySqlParameter("@MapCode", MySqlDbType.VarChar, 10),
new MySqlParameter("@Name", MySqlDbType.VarChar, 100),
new MySqlParameter("@SewageSystem_ID", MySqlDbType.VarChar, 50),
new MySqlParameter("@StormSystem_ID", MySqlDbType.VarChar, 50),
new MySqlParameter("@Type", MySqlDbType.VarChar, 4),
new MySqlParameter("@X", MySqlDbType.Decimal, 10),
new MySqlParameter("@Y", MySqlDbType.Decimal, 10),
new MySqlParameter("@High", MySqlDbType.Decimal, 10),
new MySqlParameter("@Inflow_Type", MySqlDbType.VarChar, 10),
new MySqlParameter("@Outflow_Type", MySqlDbType.VarChar, 10),
new MySqlParameter("@Total_Vol", MySqlDbType.Decimal, 7),
new MySqlParameter("@B_Level", MySqlDbType.Decimal, 10),
new MySqlParameter("@Max_Level", MySqlDbType.Decimal, 7),
new MySqlParameter("@Min_Level", MySqlDbType.Decimal, 7),
new MySqlParameter("@Design_Time", MySqlDbType.Decimal, 7),
new MySqlParameter("@Ps_Num", MySqlDbType.VarChar, 10),
new MySqlParameter("@FlowDir", MySqlDbType.VarChar, 100),
new MySqlParameter("@Code", MySqlDbType.VarChar, 10),
new MySqlParameter("@Address", MySqlDbType.VarChar, 100),
new MySqlParameter("@DataSource", MySqlDbType.VarChar, 10),
new MySqlParameter("@Sunit", MySqlDbType.VarChar, 255),
new MySqlParameter("@Sdate", MySqlDbType.VarChar, 255),
new MySqlParameter("@UpdateTime", MySqlDbType.VarChar, 255),
new MySqlParameter("@Mdate", MySqlDbType.VarChar, 255),
new MySqlParameter("@DataListID", MySqlDbType.VarChar, 50),
new MySqlParameter("@Status", MySqlDbType.VarChar, 10),
new MySqlParameter("@Ename", MySqlDbType.VarChar, 100),
new MySqlParameter("@Design_Dept", MySqlDbType.VarChar, 255),
new MySqlParameter("@Conster_Dept", MySqlDbType.VarChar, 255),
new MySqlParameter("@Belong", MySqlDbType.VarChar, 255),
new MySqlParameter("@Operator", MySqlDbType.VarChar, 255),
new MySqlParameter("@Note", MySqlDbType.VarChar, 255),
new MySqlParameter("@Exp_NoOri", MySqlDbType.VarChar, 255),
new MySqlParameter("@FileName", MySqlDbType.VarChar, 255),
new MySqlParameter("@Uploadtime", MySqlDbType.VarChar, 255),
new MySqlParameter("@Exp_No", MySqlDbType.VarChar, 100)
};
parameters[0].Value = model.Prj_No;
parameters[1].Value = model.Prj_Name;
parameters[2].Value = model.MapCode;
parameters[3].Value = model.Name;
parameters[4].Value = model.SewageSystem_ID;
parameters[5].Value = model.StormSystem_ID;
parameters[6].Value = model.Type;
parameters[7].Value = model.X;
parameters[8].Value = model.Y;
parameters[9].Value = model.High;
parameters[10].Value = model.Inflow_Type;
parameters[11].Value = model.Outflow_Type;
parameters[12].Value = model.Total_Vol;
parameters[13].Value = model.B_Level;
parameters[14].Value = model.Max_Level;
parameters[15].Value = model.Min_Level;
parameters[16].Value = model.Design_Time;
parameters[17].Value = model.Ps_Num;
parameters[18].Value = model.FlowDir;
parameters[19].Value = model.Code;
parameters[20].Value = model.Address;
parameters[21].Value = model.DataSource;
parameters[22].Value = model.Sunit;
parameters[23].Value = model.Sdate;
parameters[24].Value = model.UpdateTime;
parameters[25].Value = model.Mdate;
parameters[26].Value = model.DataListID;
parameters[27].Value = model.Status;
parameters[28].Value = model.Ename;
parameters[29].Value = model.Design_Dept;
parameters[30].Value = model.Conster_Dept;
parameters[31].Value = model.Belong;
parameters[32].Value = model.Operator;
parameters[33].Value = model.Note;
parameters[34].Value = model.Exp_NoOri;
parameters[35].Value = model.FileName;
parameters[36].Value = model.Uploadtime;
parameters[37].Value = model.Exp_No;
int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(DataAngineSet.Model.person model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update person set ");
strSql.Append("person_dataset_id=@person_dataset_id,");
strSql.Append("name=@name,");
strSql.Append("gender=@gender,");
strSql.Append("card_id=@card_id,");
strSql.Append("bitrhday=@bitrhday,");
strSql.Append("image_id=@image_id,");
strSql.Append("face_image_path=@face_image_path,");
strSql.Append("feature_data=@feature_data,");
strSql.Append("type=@type,");
strSql.Append("create_time=@create_time,");
strSql.Append("modified_time=@modified_time,");
strSql.Append("quality_score=@quality_score,");
strSql.Append("remark=@remark");
strSql.Append(" where id=@id");
MySqlParameter[] parameters =
{
new MySqlParameter("@person_dataset_id", MySqlDbType.Int32, 11),
new MySqlParameter("@name", MySqlDbType.VarChar, 50),
new MySqlParameter("@gender", MySqlDbType.VarChar, 1),
new MySqlParameter("@card_id", MySqlDbType.VarChar, 50),
new MySqlParameter("@bitrhday", MySqlDbType.DateTime),
new MySqlParameter("@image_id", MySqlDbType.VarChar, 60),
new MySqlParameter("@face_image_path", MySqlDbType.VarChar, 200),
new MySqlParameter("@feature_data", MySqlDbType.LongBlob),
new MySqlParameter("@type", MySqlDbType.VarChar, 1),
new MySqlParameter("@create_time", MySqlDbType.DateTime),
new MySqlParameter("@modified_time", MySqlDbType.DateTime),
new MySqlParameter("@quality_score", MySqlDbType.Float),
new MySqlParameter("@remark", MySqlDbType.VarChar, 50),
new MySqlParameter("@id", MySqlDbType.Int32, 11)
};
parameters[0].Value = model.person_dataset_id;
parameters[1].Value = model.name;
parameters[2].Value = model.gender;
parameters[3].Value = model.card_id;
parameters[4].Value = model.bitrhday;
parameters[5].Value = model.image_id;
parameters[6].Value = model.face_image_path;
parameters[7].Value = model.feature_data;
parameters[8].Value = model.type;
parameters[9].Value = model.create_time;
parameters[10].Value = model.modified_time;
parameters[11].Value = model.quality_score;
parameters[12].Value = model.remark;
parameters[13].Value = model.id;
int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到最大ID
/// </summary>
public int GetMaxId()
{
return(DbHelperMySQL.GetMaxID("id", "person"));
}
/// <summary>
/// 得到最大ID
/// </summary>
public int GetMaxId()
{
return(DbHelperMySQL.GetMaxID("number", "pipeobjectencode"));
}
/// <summary>
/// 得到最大ID
/// </summary>
public int GetMaxId()
{
return(DbHelperMySQL.GetMaxID("fh_id", "fault_history"));
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(fds.Model.fault_history model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update fault_history set ");
strSql.Append("fh_adduser=@fh_adduser,");
strSql.Append("ptype_id=@ptype_id,");
strSql.Append("tpoint_id=@tpoint_id,");
strSql.Append("system_id=@system_id,");
strSql.Append("fh_phenomenon=@fh_phenomenon,");
strSql.Append("fh_caseid=@fh_caseid,");
strSql.Append("fh_title=@fh_title,");
strSql.Append("fh_description=@fh_description,");
strSql.Append("fh_cause=@fh_cause,");
strSql.Append("fh_suggest=@fh_suggest,");
strSql.Append("fh_explain=@fh_explain,");
strSql.Append("fh_reference=@fh_reference,");
strSql.Append("fh_experience=@fh_experience,");
strSql.Append("fh_keywd=@fh_keywd,");
strSql.Append("fh_addtime=@fh_addtime");
strSql.Append(" where fh_id=@fh_id");
MySqlParameter[] parameters =
{
new MySqlParameter("@fh_adduser", MySqlDbType.Int32, 11),
new MySqlParameter("@ptype_id", MySqlDbType.Int32, 11),
new MySqlParameter("@tpoint_id", MySqlDbType.Int32, 11),
new MySqlParameter("@system_id", MySqlDbType.Int32, 11),
new MySqlParameter("@fh_phenomenon", MySqlDbType.VarChar, 2048),
new MySqlParameter("@fh_caseid", MySqlDbType.VarChar, 128),
new MySqlParameter("@fh_title", MySqlDbType.VarChar, 512),
new MySqlParameter("@fh_description", MySqlDbType.VarChar, 2048),
new MySqlParameter("@fh_cause", MySqlDbType.VarChar, 2048),
new MySqlParameter("@fh_suggest", MySqlDbType.VarChar, 2048),
new MySqlParameter("@fh_explain", MySqlDbType.VarChar, 2048),
new MySqlParameter("@fh_reference", MySqlDbType.VarChar, 2048),
new MySqlParameter("@fh_experience", MySqlDbType.VarChar, 2048),
new MySqlParameter("@fh_keywd", MySqlDbType.VarChar, 512),
new MySqlParameter("@fh_addtime", MySqlDbType.DateTime),
new MySqlParameter("@fh_id", MySqlDbType.Int32, 11)
};
parameters[0].Value = model.fh_adduser;
parameters[1].Value = model.ptype_id;
parameters[2].Value = model.tpoint_id;
parameters[3].Value = model.system_id;
parameters[4].Value = model.fh_phenomenon;
parameters[5].Value = model.fh_caseid;
parameters[6].Value = model.fh_title;
parameters[7].Value = model.fh_description;
parameters[8].Value = model.fh_cause;
parameters[9].Value = model.fh_suggest;
parameters[10].Value = model.fh_explain;
parameters[11].Value = model.fh_reference;
parameters[12].Value = model.fh_experience;
parameters[13].Value = model.fh_keywd;
parameters[14].Value = model.fh_addtime;
parameters[15].Value = model.fh_id;
int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到最大ID
/// </summary>
public int GetMaxId()
{
return(DbHelperMySQL.GetMaxID("kId", "extractdata_k"));
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(Maticsoft.Model.ps_retention model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into ps_retention(");
strSql.Append("Prj_No,Prj_Name,Exp_No,MapCode,Name,SewageSystem_ID,StormSystem_ID,Type,X,Y,High,Inflow_Type,Outflow_Type,Total_Vol,B_Level,Max_Level,Min_Level,Design_Time,Ps_Num,FlowDir,Code,Address,DataSource,Sunit,Sdate,UpdateTime,Mdate,DataListID,Status,Ename,Design_Dept,Conster_Dept,Belong,Operator,Note,Exp_NoOri,FileName,Uploadtime)");
strSql.Append(" values (");
strSql.Append("@Prj_No,@Prj_Name,@Exp_No,@MapCode,@Name,@SewageSystem_ID,@StormSystem_ID,@Type,@X,@Y,@High,@Inflow_Type,@Outflow_Type,@Total_Vol,@B_Level,@Max_Level,@Min_Level,@Design_Time,@Ps_Num,@FlowDir,@Code,@Address,@DataSource,@Sunit,@Sdate,@UpdateTime,@Mdate,@DataListID,@Status,@Ename,@Design_Dept,@Conster_Dept,@Belong,@Operator,@Note,@Exp_NoOri,@FileName,@Uploadtime)");
MySqlParameter[] parameters =
{
new MySqlParameter("@Prj_No", MySqlDbType.VarChar, 10),
new MySqlParameter("@Prj_Name", MySqlDbType.VarChar, 100),
new MySqlParameter("@Exp_No", MySqlDbType.VarChar, 100),
new MySqlParameter("@MapCode", MySqlDbType.VarChar, 10),
new MySqlParameter("@Name", MySqlDbType.VarChar, 100),
new MySqlParameter("@SewageSystem_ID", MySqlDbType.VarChar, 50),
new MySqlParameter("@StormSystem_ID", MySqlDbType.VarChar, 50),
new MySqlParameter("@Type", MySqlDbType.VarChar, 4),
new MySqlParameter("@X", MySqlDbType.Decimal, 10),
new MySqlParameter("@Y", MySqlDbType.Decimal, 10),
new MySqlParameter("@High", MySqlDbType.Decimal, 10),
new MySqlParameter("@Inflow_Type", MySqlDbType.VarChar, 10),
new MySqlParameter("@Outflow_Type", MySqlDbType.VarChar, 10),
new MySqlParameter("@Total_Vol", MySqlDbType.Decimal, 7),
new MySqlParameter("@B_Level", MySqlDbType.Decimal, 10),
new MySqlParameter("@Max_Level", MySqlDbType.Decimal, 7),
new MySqlParameter("@Min_Level", MySqlDbType.Decimal, 7),
new MySqlParameter("@Design_Time", MySqlDbType.Decimal, 7),
new MySqlParameter("@Ps_Num", MySqlDbType.VarChar, 10),
new MySqlParameter("@FlowDir", MySqlDbType.VarChar, 100),
new MySqlParameter("@Code", MySqlDbType.VarChar, 10),
new MySqlParameter("@Address", MySqlDbType.VarChar, 100),
new MySqlParameter("@DataSource", MySqlDbType.VarChar, 10),
new MySqlParameter("@Sunit", MySqlDbType.VarChar, 255),
new MySqlParameter("@Sdate", MySqlDbType.VarChar, 255),
new MySqlParameter("@UpdateTime", MySqlDbType.VarChar, 255),
new MySqlParameter("@Mdate", MySqlDbType.VarChar, 255),
new MySqlParameter("@DataListID", MySqlDbType.VarChar, 50),
new MySqlParameter("@Status", MySqlDbType.VarChar, 10),
new MySqlParameter("@Ename", MySqlDbType.VarChar, 100),
new MySqlParameter("@Design_Dept", MySqlDbType.VarChar, 255),
new MySqlParameter("@Conster_Dept", MySqlDbType.VarChar, 255),
new MySqlParameter("@Belong", MySqlDbType.VarChar, 255),
new MySqlParameter("@Operator", MySqlDbType.VarChar, 255),
new MySqlParameter("@Note", MySqlDbType.VarChar, 255),
new MySqlParameter("@Exp_NoOri", MySqlDbType.VarChar, 255),
new MySqlParameter("@FileName", MySqlDbType.VarChar, 255),
new MySqlParameter("@Uploadtime", MySqlDbType.VarChar, 255)
};
parameters[0].Value = model.Prj_No;
parameters[1].Value = model.Prj_Name;
parameters[2].Value = model.Exp_No;
parameters[3].Value = model.MapCode;
parameters[4].Value = model.Name;
parameters[5].Value = model.SewageSystem_ID;
parameters[6].Value = model.StormSystem_ID;
parameters[7].Value = model.Type;
parameters[8].Value = model.X;
parameters[9].Value = model.Y;
parameters[10].Value = model.High;
parameters[11].Value = model.Inflow_Type;
parameters[12].Value = model.Outflow_Type;
parameters[13].Value = model.Total_Vol;
parameters[14].Value = model.B_Level;
parameters[15].Value = model.Max_Level;
parameters[16].Value = model.Min_Level;
parameters[17].Value = model.Design_Time;
parameters[18].Value = model.Ps_Num;
parameters[19].Value = model.FlowDir;
parameters[20].Value = model.Code;
parameters[21].Value = model.Address;
parameters[22].Value = model.DataSource;
parameters[23].Value = model.Sunit;
parameters[24].Value = model.Sdate;
parameters[25].Value = model.UpdateTime;
parameters[26].Value = model.Mdate;
parameters[27].Value = model.DataListID;
parameters[28].Value = model.Status;
parameters[29].Value = model.Ename;
parameters[30].Value = model.Design_Dept;
parameters[31].Value = model.Conster_Dept;
parameters[32].Value = model.Belong;
parameters[33].Value = model.Operator;
parameters[34].Value = model.Note;
parameters[35].Value = model.Exp_NoOri;
parameters[36].Value = model.FileName;
parameters[37].Value = model.Uploadtime;
int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 根据字段列表，条件，排序，每页记录数，页码（从1开始），分页读取记录
/// </summary>
/// <param name="columslist">字段列表，如：Id,姓名,性别,年龄</param>
/// <param name="strWhere">条件，如：年龄>12 and 性别='女'</param>
/// <param name="filedOrder">排序，如： Id desc </param>
/// <param name="PageSize">每页记录数，如：30</param>
/// <param name="PageIndex">页码，如：2</param>
/// <returns>返回组装好的json字符串</returns>
public string GetListByPageColumns_tojson(string columslist, string strWhere, string orderby, int PageSize, int PageIndex)
{
string str = DbHelperMySQL.GetListByPageColumns_tojson(columslist, strWhere, orderby, PageSize, PageIndex, "tb_navigation");
return(str);
}
/// <summary>
/// 得到最大ID
/// </summary>
public int GetMaxId()
{
return(DbHelperMySQL.GetMaxID("kId", "urlconfigs_k"));
}
/// <summary>
/// 根据字段列表，条件，排序，每页记录数，页码（从1开始），分页读取记录
/// </summary>
/// <param name="columslist">字段列表，如：Id,姓名,性别,年龄</param>
/// <param name="strWhere">条件，如：年龄>12 and 性别='女'</param>
/// <param name="filedOrder">排序，如： Id desc </param>
/// <param name="PageSize">每页记录数，如：30</param>
/// <param name="PageIndex">页码，如：2</param>
/// <returns></returns>
public DataSet GetListByPageColumns(string columslist, string strWhere, string orderby, int PageSize, int PageIndex)
{
string strsql = DbHelperMySQL.GetListByPageColumns(columslist, strWhere, orderby, PageSize, PageIndex, "tb_navigation");
return(DbHelperMySQL.Query(strsql));
}
/// <summary>
/// 得到最大ID
/// </summary>
public int GetMaxId()
{
return(DbHelperMySQL.GetMaxID("id", "scm_spe_supply_set"));
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(Maticsoft.Model.ps_outfall model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into ps_outfall(");
strSql.Append("Prj_No,Prj_Name,Exp_No,MapCode,SewageSystem_ID,StormSystem_ID,Type,X,Y,High,Bottom_Elev,OutfallShape,OutfallType,Offset,Rotation,Code,Flap,Flap_Diameter,Flap_TopEle,Flap_BotEle,Flap_Materail,Receive,Address,PointPosition,DataSource,Visibility,Sunit,Sdate,UpdateTime,Mdate,Outfall_Type,Status,Ename,Design_Dept,Conster_Dept,Belong,Operator,Note,Exp_NoOri,FileName,Uploadtime)");
strSql.Append(" values (");
strSql.Append("@Prj_No,@Prj_Name,@Exp_No,@MapCode,@SewageSystem_ID,@StormSystem_ID,@Type,@X,@Y,@High,@Bottom_Elev,@OutfallShape,@OutfallType,@Offset,@Rotation,@Code,@Flap,@Flap_Diameter,@Flap_TopEle,@Flap_BotEle,@Flap_Materail,@Receive,@Address,@PointPosition,@DataSource,@Visibility,@Sunit,@Sdate,@UpdateTime,@Mdate,@Outfall_Type,@Status,@Ename,@Design_Dept,@Conster_Dept,@Belong,@Operator,@Note,@Exp_NoOri,@FileName,@Uploadtime)");
MySqlParameter[] parameters =
{
new MySqlParameter("@Prj_No", MySqlDbType.VarChar, 255),
new MySqlParameter("@Prj_Name", MySqlDbType.VarChar, 255),
new MySqlParameter("@Exp_No", MySqlDbType.VarChar, 100),
new MySqlParameter("@MapCode", MySqlDbType.VarChar, 10),
new MySqlParameter("@SewageSystem_ID", MySqlDbType.VarChar, 50),
new MySqlParameter("@StormSystem_ID", MySqlDbType.VarChar, 50),
new MySqlParameter("@Type", MySqlDbType.VarChar, 4),
new MySqlParameter("@X", MySqlDbType.Decimal, 10),
new MySqlParameter("@Y", MySqlDbType.Decimal, 10),
new MySqlParameter("@High", MySqlDbType.Decimal, 10),
new MySqlParameter("@Bottom_Elev", MySqlDbType.Decimal, 7),
new MySqlParameter("@OutfallShape", MySqlDbType.VarChar, 50),
new MySqlParameter("@OutfallType", MySqlDbType.VarChar, 10),
new MySqlParameter("@Offset", MySqlDbType.VarChar, 50),
new MySqlParameter("@Rotation", MySqlDbType.Decimal, 7),
new MySqlParameter("@Code", MySqlDbType.VarChar, 10),
new MySqlParameter("@Flap", MySqlDbType.VarChar, 10),
new MySqlParameter("@Flap_Diameter", MySqlDbType.Decimal, 7),
new MySqlParameter("@Flap_TopEle", MySqlDbType.Decimal, 7),
new MySqlParameter("@Flap_BotEle", MySqlDbType.Decimal, 7),
new MySqlParameter("@Flap_Materail", MySqlDbType.VarChar, 50),
new MySqlParameter("@Receive", MySqlDbType.VarChar, 50),
new MySqlParameter("@Address", MySqlDbType.VarChar, 100),
new MySqlParameter("@PointPosition", MySqlDbType.Int32, 10),
new MySqlParameter("@DataSource", MySqlDbType.VarChar, 10),
new MySqlParameter("@Visibility", MySqlDbType.VarChar, 4),
new MySqlParameter("@Sunit", MySqlDbType.VarChar, 255),
new MySqlParameter("@Sdate", MySqlDbType.VarChar, 255),
new MySqlParameter("@UpdateTime", MySqlDbType.VarChar, 255),
new MySqlParameter("@Mdate", MySqlDbType.VarChar, 255),
new MySqlParameter("@Outfall_Type", MySqlDbType.VarChar, 10),
new MySqlParameter("@Status", MySqlDbType.VarChar, 10),
new MySqlParameter("@Ename", MySqlDbType.VarChar, 100),
new MySqlParameter("@Design_Dept", MySqlDbType.VarChar, 255),
new MySqlParameter("@Conster_Dept", MySqlDbType.VarChar, 255),
new MySqlParameter("@Belong", MySqlDbType.VarChar, 255),
new MySqlParameter("@Operator", MySqlDbType.VarChar, 255),
new MySqlParameter("@Note", MySqlDbType.VarChar, 255),
new MySqlParameter("@Exp_NoOri", MySqlDbType.VarChar, 255),
new MySqlParameter("@FileName", MySqlDbType.VarChar, 255),
new MySqlParameter("@Uploadtime", MySqlDbType.VarChar, 255)
};
parameters[0].Value = model.Prj_No;
parameters[1].Value = model.Prj_Name;
parameters[2].Value = model.Exp_No;
parameters[3].Value = model.MapCode;
parameters[4].Value = model.SewageSystem_ID;
parameters[5].Value = model.StormSystem_ID;
parameters[6].Value = model.Type;
parameters[7].Value = model.X;
parameters[8].Value = model.Y;
parameters[9].Value = model.High;
parameters[10].Value = model.Bottom_Elev;
parameters[11].Value = model.OutfallShape;
parameters[12].Value = model.OutfallType;
parameters[13].Value = model.Offset;
parameters[14].Value = model.Rotation;
parameters[15].Value = model.Code;
parameters[16].Value = model.Flap;
parameters[17].Value = model.Flap_Diameter;
parameters[18].Value = model.Flap_TopEle;
parameters[19].Value = model.Flap_BotEle;
parameters[20].Value = model.Flap_Materail;
parameters[21].Value = model.Receive;
parameters[22].Value = model.Address;
parameters[23].Value = model.PointPosition;
parameters[24].Value = model.DataSource;
parameters[25].Value = model.Visibility;
parameters[26].Value = model.Sunit;
parameters[27].Value = model.Sdate;
parameters[28].Value = model.UpdateTime;
parameters[29].Value = model.Mdate;
parameters[30].Value = model.Outfall_Type;
parameters[31].Value = model.Status;
parameters[32].Value = model.Ename;
parameters[33].Value = model.Design_Dept;
parameters[34].Value = model.Conster_Dept;
parameters[35].Value = model.Belong;
parameters[36].Value = model.Operator;
parameters[37].Value = model.Note;
parameters[38].Value = model.Exp_NoOri;
parameters[39].Value = model.FileName;
parameters[40].Value = model.Uploadtime;
int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到最大ID
/// </summary>
public int GetMaxId()
{
return(DbHelperMySQL.GetMaxID("mess_ID", "t_message"));
}
/// <summary>
/// 得到最大ID
/// </summary>
public int GetMaxId()
{
return(DbHelperMySQL.GetMaxID("id", "bus_dish_plan"));
}
/// <summary>
/// 得到最大ID
/// </summary>
public int GetMaxId()
{
return(DbHelperMySQL.GetMaxID("id", "t_admin"));
}
/// <summary>
/// 得到最大ID
/// </summary>
public int GetMaxId()
{
return(DbHelperMySQL.GetMaxID("id", "userinfo"));
}
/// <summary>
/// 得到最大ID
/// </summary>
public int GetMaxId()
{
return(DbHelperMySQL.GetMaxID("Id", "tempvehicleinfo"));
}
/// <summary>
/// 得到最大ID
/// </summary>
public int GetMaxId()
{
return(DbHelperMySQL.GetMaxID("userId", "tuser"));
}
/// <summary>
/// 得到最大ID
/// </summary>
public int GetMaxId()
{
return(DbHelperMySQL.GetMaxID("id", "bus_verify_code"));
}
/// <summary>
/// 得到最大ID
/// </summary>
public int GetMaxId()
{
return(DbHelperMySQL.GetMaxID("id", "sys_app"));
}
public UcTaskAllocation()
{
InitializeComponent();
dbOperation = DBUtility.DbHelperMySQL.CreateDbHelper();
btnSave.Tag = "新增";
}