/// <summary>
/// 得到一个对象实体
/// </summary>
public DBinterface.Model.Meter_Install_Single GetModel(string SingleID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 SingleID,SD,AcceptID,QueryKey,loginId,userName,AcceptDate,waterUserTypeId,State,FlowID,ApplyUser,waterUserName,SubmitDate,ContractNO,waterUserAddress,IsBoost,waterUserPeopleCount,waterUserHouseType,waterPhone from Meter_Install_Single ");
strSql.Append(" where SingleID=@SingleID ");
SqlParameter[] parameters =
{
new SqlParameter("@SingleID", SqlDbType.NVarChar, 50)
};
parameters[0].Value = SingleID;
DBinterface.Model.Meter_Install_Single model = new DBinterface.Model.Meter_Install_Single();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(DBinterface.Model.Meter_Install_Single model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into Meter_Install_Single(");
strSql.Append("SingleID,SD,AcceptID,QueryKey,loginId,userName,AcceptDate,waterUserTypeId,State,FlowID,ApplyUser,waterUserName,SubmitDate,ContractNO,waterUserAddress,IsBoost,waterUserPeopleCount,waterUserHouseType,waterPhone)");
strSql.Append(" values (");
strSql.Append("@SingleID,@SD,@AcceptID,@QueryKey,@loginId,@userName,@AcceptDate,@waterUserTypeId,@State,@FlowID,@ApplyUser,@waterUserName,@SubmitDate,@ContractNO,@waterUserAddress,@IsBoost,@waterUserPeopleCount,@waterUserHouseType,@waterPhone)");
SqlParameter[] parameters =
{
new SqlParameter("@SingleID", SqlDbType.NVarChar, 50),
new SqlParameter("@SD", SqlDbType.Int, 4),
new SqlParameter("@AcceptID", SqlDbType.Int, 4),
new SqlParameter("@QueryKey", SqlDbType.Int, 4),
new SqlParameter("@loginId", SqlDbType.VarChar, 50),
new SqlParameter("@userName", SqlDbType.VarChar, 50),
new SqlParameter("@AcceptDate", SqlDbType.DateTime),
new SqlParameter("@waterUserTypeId", SqlDbType.VarChar, 30),
new SqlParameter("@State", SqlDbType.TinyInt, 1),
new SqlParameter("@FlowID", SqlDbType.NVarChar, 50),
new SqlParameter("@ApplyUser", SqlDbType.NVarChar, 50),
new SqlParameter("@waterUserName", SqlDbType.VarBinary, 70),
new SqlParameter("@SubmitDate", SqlDbType.DateTime),
new SqlParameter("@ContractNO", SqlDbType.NVarChar, 50),
new SqlParameter("@waterUserAddress", SqlDbType.VarChar, 100),
new SqlParameter("@IsBoost", SqlDbType.Bit, 1),
new SqlParameter("@waterUserPeopleCount", SqlDbType.Int, 4),
new SqlParameter("@waterUserHouseType", SqlDbType.VarChar, 10),
new SqlParameter("@waterPhone", SqlDbType.VarChar, 50)
};
parameters[0].Value = model.SingleID;
parameters[1].Value = model.SD;
parameters[2].Value = model.AcceptID;
parameters[3].Value = model.QueryKey;
parameters[4].Value = model.loginId;
parameters[5].Value = model.userName;
parameters[6].Value = model.AcceptDate;
parameters[7].Value = model.waterUserTypeId;
parameters[8].Value = model.State;
parameters[9].Value = model.FlowID;
parameters[10].Value = model.ApplyUser;
parameters[11].Value = model.waterUserName;
parameters[12].Value = model.SubmitDate;
parameters[13].Value = model.ContractNO;
parameters[14].Value = model.waterUserAddress;
parameters[15].Value = model.IsBoost;
parameters[16].Value = model.waterUserPeopleCount;
parameters[17].Value = model.waterUserHouseType;
parameters[18].Value = model.waterPhone;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public DBinterface.Model.Meter_Install_Single DataRowToModel(DataRow row)
{
DBinterface.Model.Meter_Install_Single model = new DBinterface.Model.Meter_Install_Single();
if (row != null)
{
if (row["SingleID"] != null)
{
model.SingleID = row["SingleID"].ToString();
}
if (row["SD"] != null && row["SD"].ToString() != "")
{
model.SD = int.Parse(row["SD"].ToString());
}
if (row["AcceptID"] != null && row["AcceptID"].ToString() != "")
{
model.AcceptID = int.Parse(row["AcceptID"].ToString());
}
if (row["QueryKey"] != null && row["QueryKey"].ToString() != "")
{
model.QueryKey = int.Parse(row["QueryKey"].ToString());
}
if (row["loginId"] != null)
{
model.loginId = row["loginId"].ToString();
}
if (row["userName"] != null)
{
model.userName = row["userName"].ToString();
}
if (row["AcceptDate"] != null && row["AcceptDate"].ToString() != "")
{
model.AcceptDate = DateTime.Parse(row["AcceptDate"].ToString());
}
if (row["waterUserTypeId"] != null)
{
model.waterUserTypeId = row["waterUserTypeId"].ToString();
}
if (row["State"] != null && row["State"].ToString() != "")
{
model.State = int.Parse(row["State"].ToString());
}
if (row["FlowID"] != null)
{
model.FlowID = row["FlowID"].ToString();
}
if (row["ApplyUser"] != null)
{
model.ApplyUser = row["ApplyUser"].ToString();
}
if (row["waterUserName"] != null && row["waterUserName"].ToString() != "")
{
model.waterUserName = (byte[])row["waterUserName"];
}
if (row["SubmitDate"] != null && row["SubmitDate"].ToString() != "")
{
model.SubmitDate = DateTime.Parse(row["SubmitDate"].ToString());
}
if (row["ContractNO"] != null)
{
model.ContractNO = row["ContractNO"].ToString();
}
if (row["waterUserAddress"] != null)
{
model.waterUserAddress = row["waterUserAddress"].ToString();
}
if (row["IsBoost"] != null && row["IsBoost"].ToString() != "")
{
if ((row["IsBoost"].ToString() == "1") || (row["IsBoost"].ToString().ToLower() == "true"))
{
model.IsBoost = true;
}
else
{
model.IsBoost = false;
}
}
if (row["waterUserPeopleCount"] != null && row["waterUserPeopleCount"].ToString() != "")
{
model.waterUserPeopleCount = int.Parse(row["waterUserPeopleCount"].ToString());
}
if (row["waterUserHouseType"] != null)
{
model.waterUserHouseType = row["waterUserHouseType"].ToString();
}
if (row["waterPhone"] != null)
{
model.waterPhone = row["waterPhone"].ToString();
}
}
return(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(DBinterface.Model.Meter_Install_Single model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update Meter_Install_Single set ");
strSql.Append("SD=@SD,");
strSql.Append("AcceptID=@AcceptID,");
strSql.Append("QueryKey=@QueryKey,");
strSql.Append("loginId=@loginId,");
strSql.Append("userName=@userName,");
strSql.Append("AcceptDate=@AcceptDate,");
strSql.Append("waterUserTypeId=@waterUserTypeId,");
strSql.Append("State=@State,");
strSql.Append("FlowID=@FlowID,");
strSql.Append("ApplyUser=@ApplyUser,");
strSql.Append("waterUserName=@waterUserName,");
strSql.Append("SubmitDate=@SubmitDate,");
strSql.Append("ContractNO=@ContractNO,");
strSql.Append("waterUserAddress=@waterUserAddress,");
strSql.Append("IsBoost=@IsBoost,");
strSql.Append("waterUserPeopleCount=@waterUserPeopleCount,");
strSql.Append("waterUserHouseType=@waterUserHouseType,");
strSql.Append("waterPhone=@waterPhone");
strSql.Append(" where SingleID=@SingleID ");
SqlParameter[] parameters =
{
new SqlParameter("@SD", SqlDbType.Int, 4),
new SqlParameter("@AcceptID", SqlDbType.Int, 4),
new SqlParameter("@QueryKey", SqlDbType.Int, 4),
new SqlParameter("@loginId", SqlDbType.VarChar, 50),
new SqlParameter("@userName", SqlDbType.VarChar, 50),
new SqlParameter("@AcceptDate", SqlDbType.DateTime),
new SqlParameter("@waterUserTypeId", SqlDbType.VarChar, 30),
new SqlParameter("@State", SqlDbType.TinyInt, 1),
new SqlParameter("@FlowID", SqlDbType.NVarChar, 50),
new SqlParameter("@ApplyUser", SqlDbType.NVarChar, 50),
new SqlParameter("@waterUserName", SqlDbType.VarBinary, 70),
new SqlParameter("@SubmitDate", SqlDbType.DateTime),
new SqlParameter("@ContractNO", SqlDbType.NVarChar, 50),
new SqlParameter("@waterUserAddress", SqlDbType.VarChar, 100),
new SqlParameter("@IsBoost", SqlDbType.Bit, 1),
new SqlParameter("@waterUserPeopleCount", SqlDbType.Int, 4),
new SqlParameter("@waterUserHouseType", SqlDbType.VarChar, 10),
new SqlParameter("@waterPhone", SqlDbType.VarChar, 50),
new SqlParameter("@SingleID", SqlDbType.NVarChar, 50)
};
parameters[0].Value = model.SD;
parameters[1].Value = model.AcceptID;
parameters[2].Value = model.QueryKey;
parameters[3].Value = model.loginId;
parameters[4].Value = model.userName;
parameters[5].Value = model.AcceptDate;
parameters[6].Value = model.waterUserTypeId;
parameters[7].Value = model.State;
parameters[8].Value = model.FlowID;
parameters[9].Value = model.ApplyUser;
parameters[10].Value = model.waterUserName;
parameters[11].Value = model.SubmitDate;
parameters[12].Value = model.ContractNO;
parameters[13].Value = model.waterUserAddress;
parameters[14].Value = model.IsBoost;
parameters[15].Value = model.waterUserPeopleCount;
parameters[16].Value = model.waterUserHouseType;
parameters[17].Value = model.waterPhone;
parameters[18].Value = model.SingleID;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
