/// <summary>
/// 得到一个对象实体
/// </summary>
public IPSP.Model.TTCase_Trademark GetModel(int n_CaseID, int n_LawID, int ObjectType)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 n_CaseID,n_GroupID,n_LawID,n_TFlowNum,s_TrademarkDesc,s_TrademarkType,s_TrademarkClass,s_IsMultClass,s_CollectiveApp,img_MainOrigImg,img_MainThumbnail,s_ApplyType,n_MadBasicCountry,s_MadBasicType,ObjectType,s_Notes,s_TrademarkStatus,s_OldSerial,s_GooodsNames,b_DivisionalCaseFlag,s_OrigAppNo,dt_OrigAppDate,s_OrigCaseNo,dt_DivSubmitDate,s_PriorityFileBackup from TTCase_Trademark ");
strSql.Append(" where n_CaseID=@n_CaseID and n_LawID=@n_LawID and ObjectType=@ObjectType ");
SqlParameter[] parameters =
{
new SqlParameter("@n_CaseID", SqlDbType.Int, 4),
new SqlParameter("@n_LawID", SqlDbType.Int, 4),
new SqlParameter("@ObjectType", SqlDbType.Int, 4)
};
parameters[0].Value = n_CaseID;
parameters[1].Value = n_LawID;
parameters[2].Value = ObjectType;
IPSP.Model.TTCase_Trademark model = new IPSP.Model.TTCase_Trademark();
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 Update(IPSP.Model.TTCase_Trademark model)
{
return(dal.Update(model));
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(IPSP.Model.TTCase_Trademark model)
{
return(dal.Add(model));
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(IPSP.Model.TTCase_Trademark model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into TTCase_Trademark(");
strSql.Append("n_CaseID,n_GroupID,n_LawID,n_TFlowNum,s_TrademarkDesc,s_TrademarkType,s_TrademarkClass,s_IsMultClass,s_CollectiveApp,img_MainOrigImg,img_MainThumbnail,s_ApplyType,n_MadBasicCountry,s_MadBasicType,ObjectType,s_Notes,s_TrademarkStatus,s_OldSerial,s_GooodsNames,b_DivisionalCaseFlag,s_OrigAppNo,dt_OrigAppDate,s_OrigCaseNo,dt_DivSubmitDate,s_PriorityFileBackup)");
strSql.Append(" values (");
strSql.Append("@n_CaseID,@n_GroupID,@n_LawID,@n_TFlowNum,@s_TrademarkDesc,@s_TrademarkType,@s_TrademarkClass,@s_IsMultClass,@s_CollectiveApp,@img_MainOrigImg,@img_MainThumbnail,@s_ApplyType,@n_MadBasicCountry,@s_MadBasicType,@ObjectType,@s_Notes,@s_TrademarkStatus,@s_OldSerial,@s_GooodsNames,@b_DivisionalCaseFlag,@s_OrigAppNo,@dt_OrigAppDate,@s_OrigCaseNo,@dt_DivSubmitDate,@s_PriorityFileBackup)");
SqlParameter[] parameters =
{
new SqlParameter("@n_CaseID", SqlDbType.Int, 4),
new SqlParameter("@n_GroupID", SqlDbType.Int, 4),
new SqlParameter("@n_LawID", SqlDbType.Int, 4),
new SqlParameter("@n_TFlowNum", SqlDbType.Int, 4),
new SqlParameter("@s_TrademarkDesc", SqlDbType.NVarChar, 500),
new SqlParameter("@s_TrademarkType", SqlDbType.NVarChar, 100),
new SqlParameter("@s_TrademarkClass", SqlDbType.NVarChar, 200),
new SqlParameter("@s_IsMultClass", SqlDbType.NVarChar, 1),
new SqlParameter("@s_CollectiveApp", SqlDbType.NVarChar, 1),
new SqlParameter("@img_MainOrigImg", SqlDbType.VarBinary, -1),
new SqlParameter("@img_MainThumbnail", SqlDbType.VarBinary, -1),
new SqlParameter("@s_ApplyType", SqlDbType.NVarChar, 1),
new SqlParameter("@n_MadBasicCountry", SqlDbType.Int, 4),
new SqlParameter("@s_MadBasicType", SqlDbType.NVarChar, 1),
new SqlParameter("@ObjectType", SqlDbType.Int, 4),
new SqlParameter("@s_Notes", SqlDbType.NVarChar, 800),
new SqlParameter("@s_TrademarkStatus", SqlDbType.NVarChar, 50),
new SqlParameter("@s_OldSerial", SqlDbType.NVarChar, 100),
new SqlParameter("@s_GooodsNames", SqlDbType.NVarChar, -1),
new SqlParameter("@b_DivisionalCaseFlag", SqlDbType.Bit, 1),
new SqlParameter("@s_OrigAppNo", SqlDbType.NVarChar, 50),
new SqlParameter("@dt_OrigAppDate", SqlDbType.DateTime),
new SqlParameter("@s_OrigCaseNo", SqlDbType.NVarChar, 50),
new SqlParameter("@dt_DivSubmitDate", SqlDbType.DateTime),
new SqlParameter("@s_PriorityFileBackup", SqlDbType.NVarChar, 1)
};
parameters[0].Value = model.n_CaseID;
parameters[1].Value = model.n_GroupID;
parameters[2].Value = model.n_LawID;
parameters[3].Value = model.n_TFlowNum;
parameters[4].Value = model.s_TrademarkDesc;
parameters[5].Value = model.s_TrademarkType;
parameters[6].Value = model.s_TrademarkClass;
parameters[7].Value = model.s_IsMultClass;
parameters[8].Value = model.s_CollectiveApp;
parameters[9].Value = model.img_MainOrigImg;
parameters[10].Value = model.img_MainThumbnail;
parameters[11].Value = model.s_ApplyType;
parameters[12].Value = model.n_MadBasicCountry;
parameters[13].Value = model.s_MadBasicType;
parameters[14].Value = model.ObjectType;
parameters[15].Value = model.s_Notes;
parameters[16].Value = model.s_TrademarkStatus;
parameters[17].Value = model.s_OldSerial;
parameters[18].Value = model.s_GooodsNames;
parameters[19].Value = model.b_DivisionalCaseFlag;
parameters[20].Value = model.s_OrigAppNo;
parameters[21].Value = model.dt_OrigAppDate;
parameters[22].Value = model.s_OrigCaseNo;
parameters[23].Value = model.dt_DivSubmitDate;
parameters[24].Value = model.s_PriorityFileBackup;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public IPSP.Model.TTCase_Trademark DataRowToModel(DataRow row)
{
IPSP.Model.TTCase_Trademark model = new IPSP.Model.TTCase_Trademark();
if (row != null)
{
if (row["n_CaseID"] != null && row["n_CaseID"].ToString() != "")
{
model.n_CaseID = int.Parse(row["n_CaseID"].ToString());
}
if (row["n_GroupID"] != null && row["n_GroupID"].ToString() != "")
{
model.n_GroupID = int.Parse(row["n_GroupID"].ToString());
}
if (row["n_LawID"] != null && row["n_LawID"].ToString() != "")
{
model.n_LawID = int.Parse(row["n_LawID"].ToString());
}
if (row["n_TFlowNum"] != null && row["n_TFlowNum"].ToString() != "")
{
model.n_TFlowNum = int.Parse(row["n_TFlowNum"].ToString());
}
if (row["s_TrademarkDesc"] != null)
{
model.s_TrademarkDesc = row["s_TrademarkDesc"].ToString();
}
if (row["s_TrademarkType"] != null)
{
model.s_TrademarkType = row["s_TrademarkType"].ToString();
}
if (row["s_TrademarkClass"] != null)
{
model.s_TrademarkClass = row["s_TrademarkClass"].ToString();
}
if (row["s_IsMultClass"] != null)
{
model.s_IsMultClass = row["s_IsMultClass"].ToString();
}
if (row["s_CollectiveApp"] != null)
{
model.s_CollectiveApp = row["s_CollectiveApp"].ToString();
}
if (row["img_MainOrigImg"] != null && row["img_MainOrigImg"].ToString() != "")
{
model.img_MainOrigImg = (byte[])row["img_MainOrigImg"];
}
if (row["img_MainThumbnail"] != null && row["img_MainThumbnail"].ToString() != "")
{
model.img_MainThumbnail = (byte[])row["img_MainThumbnail"];
}
if (row["s_ApplyType"] != null)
{
model.s_ApplyType = row["s_ApplyType"].ToString();
}
if (row["n_MadBasicCountry"] != null && row["n_MadBasicCountry"].ToString() != "")
{
model.n_MadBasicCountry = int.Parse(row["n_MadBasicCountry"].ToString());
}
if (row["s_MadBasicType"] != null)
{
model.s_MadBasicType = row["s_MadBasicType"].ToString();
}
if (row["ObjectType"] != null && row["ObjectType"].ToString() != "")
{
model.ObjectType = int.Parse(row["ObjectType"].ToString());
}
if (row["s_Notes"] != null)
{
model.s_Notes = row["s_Notes"].ToString();
}
if (row["s_TrademarkStatus"] != null)
{
model.s_TrademarkStatus = row["s_TrademarkStatus"].ToString();
}
if (row["s_OldSerial"] != null)
{
model.s_OldSerial = row["s_OldSerial"].ToString();
}
if (row["s_GooodsNames"] != null)
{
model.s_GooodsNames = row["s_GooodsNames"].ToString();
}
if (row["b_DivisionalCaseFlag"] != null && row["b_DivisionalCaseFlag"].ToString() != "")
{
if ((row["b_DivisionalCaseFlag"].ToString() == "1") || (row["b_DivisionalCaseFlag"].ToString().ToLower() == "true"))
{
model.b_DivisionalCaseFlag = true;
}
else
{
model.b_DivisionalCaseFlag = false;
}
}
if (row["s_OrigAppNo"] != null)
{
model.s_OrigAppNo = row["s_OrigAppNo"].ToString();
}
if (row["dt_OrigAppDate"] != null && row["dt_OrigAppDate"].ToString() != "")
{
model.dt_OrigAppDate = DateTime.Parse(row["dt_OrigAppDate"].ToString());
}
if (row["s_OrigCaseNo"] != null)
{
model.s_OrigCaseNo = row["s_OrigCaseNo"].ToString();
}
if (row["dt_DivSubmitDate"] != null && row["dt_DivSubmitDate"].ToString() != "")
{
model.dt_DivSubmitDate = DateTime.Parse(row["dt_DivSubmitDate"].ToString());
}
if (row["s_PriorityFileBackup"] != null)
{
model.s_PriorityFileBackup = row["s_PriorityFileBackup"].ToString();
}
}
return(model);
}