/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(MDL.MaterialFieldMDL model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update materialfield set ");
strSql.Append("MaterialCode=@MaterialCode,");
strSql.Append("MaterialName=@MaterialName,");
strSql.Append("TableName=@TableName,");
strSql.Append("FieldName=@FieldName,");
strSql.Append("Desc=@Desc");
strSql.Append(" where TID=@TID");
SqlParameter[] parameters =
{
new SqlParameter("@MaterialCode", model.MaterialCode),
new SqlParameter("@MaterialName", model.MaterialName),
new SqlParameter("@TableName", model.TableName),
new SqlParameter("@FieldName", model.FieldName),
new SqlParameter("@Desc", model.Desc),
new SqlParameter("@TID", model.TID)
};
int rows = helper.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public MDL.MaterialFieldMDL DataRowToModel(DataRow row)
{
MDL.MaterialFieldMDL model = new MDL.MaterialFieldMDL();
if (row != null)
{
if (row["TID"] != null && row["TID"].ToString() != "")
{
model.TID = long.Parse(row["TID"].ToString());
}
if (row["MaterialCode"] != null)
{
model.MaterialCode = row["MaterialCode"].ToString();
}
if (row["MaterialName"] != null)
{
model.MaterialName = row["MaterialName"].ToString();
}
if (row["TableName"] != null)
{
model.TableName = row["TableName"].ToString();
}
if (row["FieldName"] != null)
{
model.FieldName = row["FieldName"].ToString();
}
if (row["Desc"] != null)
{
model.Desc = row["Desc"].ToString();
}
}
return(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(MDL.MaterialFieldMDL model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into materialfield(");
strSql.Append("MaterialCode,MaterialName,TableName,FieldName,[Desc] )");
strSql.Append(" values (");
strSql.Append("@MaterialCode,@MaterialName,@TableName,@FieldName,@Desc)");
SqlParameter[] parameters =
{
new SqlParameter("@MaterialCode", SqlDbType.VarChar, 20),
new SqlParameter("@MaterialName", SqlDbType.VarChar, 45),
new SqlParameter("@TableName", SqlDbType.VarChar, 45),
new SqlParameter("@FieldName", SqlDbType.VarChar, 45),
new SqlParameter("@Desc", SqlDbType.VarChar, 128)
};
parameters[0].Value = model.MaterialCode;
parameters[1].Value = model.MaterialName;
parameters[2].Value = model.TableName;
parameters[3].Value = model.FieldName;
parameters[4].Value = model.Desc;
int rows = helper.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(MDL.MaterialFieldMDL model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into materialfield(");
strSql.Append("TID,MaterialCode,MaterialName,TableName,FieldName,`Desc` )");
strSql.Append(" values (");
strSql.Append("@TID,@MaterialCode,@MaterialName,@TableName,@FieldName,@Desc)");
SQLiteParameter[] parameters =
{
new SQLiteParameter("@TID", model.TID),
new SQLiteParameter("@MaterialCode", model.MaterialCode),
new SQLiteParameter("@MaterialName", model.MaterialName),
new SQLiteParameter("@TableName", model.TableName),
new SQLiteParameter("@FieldName", model.FieldName),
new SQLiteParameter("@Desc", model.Desc)
};
int rows = SQLiteHelper.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public MDL.MaterialFieldMDL GetModel(string where)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select TOP 1 TID,MaterialCode,MaterialName,TableName,FieldName,[Desc] from materialfield ");
if (!string.IsNullOrEmpty(where))
{
strSql.Append(" where " + where);
}
MDL.MaterialFieldMDL model = new MDL.MaterialFieldMDL();
DataSet ds = helper.Query(strSql.ToString());
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public MDL.MaterialFieldMDL GetModel(string MaterialCode)
{
Dictionary <string, object> dict = new Dictionary <string, object>();
dict.Add("do", "get");
dict.Add("method", "model");
dict.Add("MaterialCode", MaterialCode);
string str = Http.POST(requestUrl, dict);
var obj = JsonHelper.JsonDeSerializer <ReturnInfo>(str);
ReturnInfo ReturnData = (ReturnInfo)obj;
if (ReturnData != null && ReturnData.Code == "1")
{
var data = JsonHelper.JsonDeSerializer <MDL.MaterialFieldMDL>(ReturnData.Data.ToString());
MDL.MaterialFieldMDL Model = (MDL.MaterialFieldMDL)data;
return(Model);
}
else
{
return(null);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public MDL.MaterialFieldMDL GetModel(long TID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select TID,MaterialCode,MaterialName,TableName,FieldName,`Desc` from materialfield ");
strSql.Append(" where TID=@TID");
SQLiteParameter[] parameters =
{
new SQLiteParameter("@TID", TID)
};
MDL.MaterialFieldMDL model = new MDL.MaterialFieldMDL();
DataSet ds = SQLiteHelper.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
