protected Model.MsgConfigModel AutoBindDataReader(SqlDataReader dr, params string[] fields)
{
var model = new Model.MsgConfigModel();
if (DbTool.HasFields("Id", fields))
{
model.Id = DbTool.ConvertObject <System.Int32>(dr["Id"]);
}
if (DbTool.HasFields("SupplierId", fields))
{
model.SupplierId = DbTool.ConvertObject <System.Int32>(dr["SupplierId"]);
}
if (DbTool.HasFields("MsgType", fields))
{
model.MsgType = DbTool.ConvertObject <System.String>(dr["MsgType"]);
}
if (DbTool.HasFields("MsgTitle", fields))
{
model.MsgTitle = DbTool.ConvertObject <System.String>(dr["MsgTitle"]);
}
if (DbTool.HasFields("MsgTemp", fields))
{
model.MsgTemp = DbTool.ConvertObject <System.String>(dr["MsgTemp"]);
}
return(model);
}
protected void BindDataReader(Model.MsgConfigModel model, SqlDataReader dr)
{
model.Id = DbTool.ConvertObject <System.Int32>(dr["Id"]);
model.SupplierId = DbTool.ConvertObject <System.Int32>(dr["SupplierId"]);
model.MsgType = DbTool.ConvertObject <System.String>(dr["MsgType"]);
model.MsgTitle = DbTool.ConvertObject <System.String>(dr["MsgTitle"]);
model.MsgTemp = DbTool.ConvertObject <System.String>(dr["MsgTemp"]);
}
public Model.MsgConfigModel GetModel(int Id)
{
string sql = "select top 1 * from MsgConfig where Id =" + Id;
Model.MsgConfigModel model = new Model.MsgConfigModel();
SqlDataReader dr = SqlHelper.ExecuteReader(conn, CommandType.Text, sql.ToString());
if (dr.Read())
{
//var fields = DbTool.GetReaderFieldNames(dr);
//model = AutoBindDataReader(dr, fields);
BindDataReader(model, dr);
}
dr.Close();
return(model);
}
public static string GetMsg(int MsgId, string mob = "", string ordercode = "")
{
Db.MsgConfigDal msgdal = new Db.MsgConfigDal();
Model.MsgConfigModel msgdel = msgdal.GetModel(MsgId);
if (string.IsNullOrEmpty(msgdel.MsgTemp))
{
msgdel.MsgTemp = "";
}
if (string.IsNullOrEmpty(mob) == false && string.IsNullOrEmpty(ordercode) == false && msgdel.MsgTemp.Length > 10)
{
Common.MessageApi.SendMessage(msgdel.MsgTemp, mob, msgdel.MsgType, msgdel.SupplierId
, Common.TypeHelper.ObjectToInt(GetKeyConfig(20).Val, 0), GetKeyConfig(21).Val);
AddLog(0, mob, ordercode, msgdel.MsgTemp);
}
return(msgdel.MsgTemp);
}
public int Add(Model.MsgConfigModel model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into [MsgConfig]");
strSql.Append("(SupplierId,MsgType,MsgTitle,MsgTemp)");
strSql.Append(" values (@SupplierId,@MsgType,@MsgTitle,@MsgTemp)");
strSql.Append(";select SCOPE_IDENTITY()");
SqlParameter[] parameters =
{
new SqlParameter("@SupplierId", DbTool.FixSqlParameter(model.SupplierId))
, new SqlParameter("@MsgType", DbTool.FixSqlParameter(model.MsgType))
, new SqlParameter("@MsgTitle", DbTool.FixSqlParameter(model.MsgTitle))
, new SqlParameter("@MsgTemp", DbTool.FixSqlParameter(model.MsgTemp))
};
return(DbTool.ConvertObject <int>(SqlHelper.ExecuteScalar(conn, CommandType.Text, strSql.ToString(), parameters), 0));
}
public List <Model.MsgConfigModel> GetModelList()
{
List <Model.MsgConfigModel> result = new List <Model.MsgConfigModel>();
string sql = "select * from MsgConfig where 1=1";
Model.MsgConfigModel model = new Model.MsgConfigModel();
SqlDataReader dr = SqlHelper.ExecuteReader(conn, CommandType.Text, sql.ToString());
//var fields = DbTool.GetReaderFieldNames(dr);
while (dr.Read())
{
//model = AutoBindDataReader(dr, fields);
model = new Model.MsgConfigModel();
BindDataReader(model, dr);
result.Add(model);
}
dr.Close();
return(result);
}
public int Update(Model.MsgConfigModel model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update MsgConfig set ");
strSql.Append("SupplierId=@SupplierId,MsgType=@MsgType,MsgTitle=@MsgTitle,MsgTemp=@MsgTemp ");
strSql.Append(" where Id=@Id ");
SqlParameter[] parameters =
{
new SqlParameter("@SupplierId", DbTool.FixSqlParameter(model.SupplierId))
, new SqlParameter("@MsgType", DbTool.FixSqlParameter(model.MsgType))
, new SqlParameter("@MsgTitle", DbTool.FixSqlParameter(model.MsgTitle))
, new SqlParameter("@MsgTemp", DbTool.FixSqlParameter(model.MsgTemp))
, new SqlParameter("@Id", model.Id)
};
return(SqlHelper.ExecuteNonQuery(conn, CommandType.Text, strSql.ToString(), parameters));
}
