/// <summary>
/// 得到一个对象实体
/// </summary>
public IPSP.Model.TPCase_LawInfo GetModel(int n_ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 n_ID,s_AppNo,dt_AppDate,n_ClaimCount,s_PubNo,dt_PubDate,s_PubVolume,s_PubGazette,s_PubClass1,s_PubClass2,dt_SubstantiveExamDate,s_IssuedPubNo,dt_IssuedPubDate,s_IssuedPubVolume,s_IssuedPubGazette,s_IssuedPubClass1,s_IssuedPubClass2,s_CertfNo,dt_CertfDate,s_PCTAppNo,dt_PctAppDate,s_PCTPubNo,dt_PctPubDate,dt_PctInNationDate,n_PCTPubLan,n_ManualPages,n_ProtectionDuration,dt_ExpirationDate,s_PCTSearchBureau,dt_FirstCheckDate,s_ReviewNo from TPCase_LawInfo ");
strSql.Append(" where n_ID=@n_ID");
SqlParameter[] parameters =
{
new SqlParameter("@n_ID", SqlDbType.Int, 4)
};
parameters[0].Value = n_ID;
IPSP.Model.TPCase_LawInfo model = new IPSP.Model.TPCase_LawInfo();
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.TPCase_LawInfo model)
{
return(dal.Update(model));
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(IPSP.Model.TPCase_LawInfo model)
{
return(dal.Add(model));
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(IPSP.Model.TPCase_LawInfo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into TPCase_LawInfo(");
strSql.Append("s_AppNo,dt_AppDate,n_ClaimCount,s_PubNo,dt_PubDate,s_PubVolume,s_PubGazette,s_PubClass1,s_PubClass2,dt_SubstantiveExamDate,s_IssuedPubNo,dt_IssuedPubDate,s_IssuedPubVolume,s_IssuedPubGazette,s_IssuedPubClass1,s_IssuedPubClass2,s_CertfNo,dt_CertfDate,s_PCTAppNo,dt_PctAppDate,s_PCTPubNo,dt_PctPubDate,dt_PctInNationDate,n_PCTPubLan,n_ManualPages,n_ProtectionDuration,dt_ExpirationDate,s_PCTSearchBureau,dt_FirstCheckDate,s_ReviewNo)");
strSql.Append(" values (");
strSql.Append("@s_AppNo,@dt_AppDate,@n_ClaimCount,@s_PubNo,@dt_PubDate,@s_PubVolume,@s_PubGazette,@s_PubClass1,@s_PubClass2,@dt_SubstantiveExamDate,@s_IssuedPubNo,@dt_IssuedPubDate,@s_IssuedPubVolume,@s_IssuedPubGazette,@s_IssuedPubClass1,@s_IssuedPubClass2,@s_CertfNo,@dt_CertfDate,@s_PCTAppNo,@dt_PctAppDate,@s_PCTPubNo,@dt_PctPubDate,@dt_PctInNationDate,@n_PCTPubLan,@n_ManualPages,@n_ProtectionDuration,@dt_ExpirationDate,@s_PCTSearchBureau,@dt_FirstCheckDate,@s_ReviewNo)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@s_AppNo", SqlDbType.NVarChar, 50),
new SqlParameter("@dt_AppDate", SqlDbType.DateTime),
new SqlParameter("@n_ClaimCount", SqlDbType.Int, 4),
new SqlParameter("@s_PubNo", SqlDbType.NVarChar, 50),
new SqlParameter("@dt_PubDate", SqlDbType.DateTime),
new SqlParameter("@s_PubVolume", SqlDbType.NVarChar, 50),
new SqlParameter("@s_PubGazette", SqlDbType.NVarChar, 50),
new SqlParameter("@s_PubClass1", SqlDbType.NVarChar, 50),
new SqlParameter("@s_PubClass2", SqlDbType.NVarChar, 50),
new SqlParameter("@dt_SubstantiveExamDate", SqlDbType.DateTime),
new SqlParameter("@s_IssuedPubNo", SqlDbType.NVarChar, 50),
new SqlParameter("@dt_IssuedPubDate", SqlDbType.DateTime),
new SqlParameter("@s_IssuedPubVolume", SqlDbType.NVarChar, 50),
new SqlParameter("@s_IssuedPubGazette", SqlDbType.NVarChar, 50),
new SqlParameter("@s_IssuedPubClass1", SqlDbType.NVarChar, 50),
new SqlParameter("@s_IssuedPubClass2", SqlDbType.NVarChar, 50),
new SqlParameter("@s_CertfNo", SqlDbType.NVarChar, 50),
new SqlParameter("@dt_CertfDate", SqlDbType.DateTime),
new SqlParameter("@s_PCTAppNo", SqlDbType.NVarChar, 50),
new SqlParameter("@dt_PctAppDate", SqlDbType.DateTime),
new SqlParameter("@s_PCTPubNo", SqlDbType.NVarChar, 50),
new SqlParameter("@dt_PctPubDate", SqlDbType.DateTime),
new SqlParameter("@dt_PctInNationDate", SqlDbType.DateTime),
new SqlParameter("@n_PCTPubLan", SqlDbType.Int, 4),
new SqlParameter("@n_ManualPages", SqlDbType.Int, 4),
new SqlParameter("@n_ProtectionDuration", SqlDbType.Decimal, 9),
new SqlParameter("@dt_ExpirationDate", SqlDbType.DateTime),
new SqlParameter("@s_PCTSearchBureau", SqlDbType.NVarChar, 200),
new SqlParameter("@dt_FirstCheckDate", SqlDbType.DateTime),
new SqlParameter("@s_ReviewNo", SqlDbType.NVarChar, 50)
};
parameters[0].Value = model.s_AppNo;
parameters[1].Value = model.dt_AppDate;
parameters[2].Value = model.n_ClaimCount;
parameters[3].Value = model.s_PubNo;
parameters[4].Value = model.dt_PubDate;
parameters[5].Value = model.s_PubVolume;
parameters[6].Value = model.s_PubGazette;
parameters[7].Value = model.s_PubClass1;
parameters[8].Value = model.s_PubClass2;
parameters[9].Value = model.dt_SubstantiveExamDate;
parameters[10].Value = model.s_IssuedPubNo;
parameters[11].Value = model.dt_IssuedPubDate;
parameters[12].Value = model.s_IssuedPubVolume;
parameters[13].Value = model.s_IssuedPubGazette;
parameters[14].Value = model.s_IssuedPubClass1;
parameters[15].Value = model.s_IssuedPubClass2;
parameters[16].Value = model.s_CertfNo;
parameters[17].Value = model.dt_CertfDate;
parameters[18].Value = model.s_PCTAppNo;
parameters[19].Value = model.dt_PctAppDate;
parameters[20].Value = model.s_PCTPubNo;
parameters[21].Value = model.dt_PctPubDate;
parameters[22].Value = model.dt_PctInNationDate;
parameters[23].Value = model.n_PCTPubLan;
parameters[24].Value = model.n_ManualPages;
parameters[25].Value = model.n_ProtectionDuration;
parameters[26].Value = model.dt_ExpirationDate;
parameters[27].Value = model.s_PCTSearchBureau;
parameters[28].Value = model.dt_FirstCheckDate;
parameters[29].Value = model.s_ReviewNo;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public IPSP.Model.TPCase_LawInfo DataRowToModel(DataRow row)
{
IPSP.Model.TPCase_LawInfo model = new IPSP.Model.TPCase_LawInfo();
if (row != null)
{
if (row["n_ID"] != null && row["n_ID"].ToString() != "")
{
model.n_ID = int.Parse(row["n_ID"].ToString());
}
if (row["s_AppNo"] != null)
{
model.s_AppNo = row["s_AppNo"].ToString();
}
if (row["dt_AppDate"] != null && row["dt_AppDate"].ToString() != "")
{
model.dt_AppDate = DateTime.Parse(row["dt_AppDate"].ToString());
}
if (row["n_ClaimCount"] != null && row["n_ClaimCount"].ToString() != "")
{
model.n_ClaimCount = int.Parse(row["n_ClaimCount"].ToString());
}
if (row["s_PubNo"] != null)
{
model.s_PubNo = row["s_PubNo"].ToString();
}
if (row["dt_PubDate"] != null && row["dt_PubDate"].ToString() != "")
{
model.dt_PubDate = DateTime.Parse(row["dt_PubDate"].ToString());
}
if (row["s_PubVolume"] != null)
{
model.s_PubVolume = row["s_PubVolume"].ToString();
}
if (row["s_PubGazette"] != null)
{
model.s_PubGazette = row["s_PubGazette"].ToString();
}
if (row["s_PubClass1"] != null)
{
model.s_PubClass1 = row["s_PubClass1"].ToString();
}
if (row["s_PubClass2"] != null)
{
model.s_PubClass2 = row["s_PubClass2"].ToString();
}
if (row["dt_SubstantiveExamDate"] != null && row["dt_SubstantiveExamDate"].ToString() != "")
{
model.dt_SubstantiveExamDate = DateTime.Parse(row["dt_SubstantiveExamDate"].ToString());
}
if (row["s_IssuedPubNo"] != null)
{
model.s_IssuedPubNo = row["s_IssuedPubNo"].ToString();
}
if (row["dt_IssuedPubDate"] != null && row["dt_IssuedPubDate"].ToString() != "")
{
model.dt_IssuedPubDate = DateTime.Parse(row["dt_IssuedPubDate"].ToString());
}
if (row["s_IssuedPubVolume"] != null)
{
model.s_IssuedPubVolume = row["s_IssuedPubVolume"].ToString();
}
if (row["s_IssuedPubGazette"] != null)
{
model.s_IssuedPubGazette = row["s_IssuedPubGazette"].ToString();
}
if (row["s_IssuedPubClass1"] != null)
{
model.s_IssuedPubClass1 = row["s_IssuedPubClass1"].ToString();
}
if (row["s_IssuedPubClass2"] != null)
{
model.s_IssuedPubClass2 = row["s_IssuedPubClass2"].ToString();
}
if (row["s_CertfNo"] != null)
{
model.s_CertfNo = row["s_CertfNo"].ToString();
}
if (row["dt_CertfDate"] != null && row["dt_CertfDate"].ToString() != "")
{
model.dt_CertfDate = DateTime.Parse(row["dt_CertfDate"].ToString());
}
if (row["s_PCTAppNo"] != null)
{
model.s_PCTAppNo = row["s_PCTAppNo"].ToString();
}
if (row["dt_PctAppDate"] != null && row["dt_PctAppDate"].ToString() != "")
{
model.dt_PctAppDate = DateTime.Parse(row["dt_PctAppDate"].ToString());
}
if (row["s_PCTPubNo"] != null)
{
model.s_PCTPubNo = row["s_PCTPubNo"].ToString();
}
if (row["dt_PctPubDate"] != null && row["dt_PctPubDate"].ToString() != "")
{
model.dt_PctPubDate = DateTime.Parse(row["dt_PctPubDate"].ToString());
}
if (row["dt_PctInNationDate"] != null && row["dt_PctInNationDate"].ToString() != "")
{
model.dt_PctInNationDate = DateTime.Parse(row["dt_PctInNationDate"].ToString());
}
if (row["n_PCTPubLan"] != null && row["n_PCTPubLan"].ToString() != "")
{
model.n_PCTPubLan = int.Parse(row["n_PCTPubLan"].ToString());
}
if (row["n_ManualPages"] != null && row["n_ManualPages"].ToString() != "")
{
model.n_ManualPages = int.Parse(row["n_ManualPages"].ToString());
}
if (row["n_ProtectionDuration"] != null && row["n_ProtectionDuration"].ToString() != "")
{
model.n_ProtectionDuration = decimal.Parse(row["n_ProtectionDuration"].ToString());
}
if (row["dt_ExpirationDate"] != null && row["dt_ExpirationDate"].ToString() != "")
{
model.dt_ExpirationDate = DateTime.Parse(row["dt_ExpirationDate"].ToString());
}
if (row["s_PCTSearchBureau"] != null)
{
model.s_PCTSearchBureau = row["s_PCTSearchBureau"].ToString();
}
if (row["dt_FirstCheckDate"] != null && row["dt_FirstCheckDate"].ToString() != "")
{
model.dt_FirstCheckDate = DateTime.Parse(row["dt_FirstCheckDate"].ToString());
}
if (row["s_ReviewNo"] != null)
{
model.s_ReviewNo = row["s_ReviewNo"].ToString();
}
}
return(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(IPSP.Model.TPCase_LawInfo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update TPCase_LawInfo set ");
strSql.Append("s_AppNo=@s_AppNo,");
strSql.Append("dt_AppDate=@dt_AppDate,");
strSql.Append("n_ClaimCount=@n_ClaimCount,");
strSql.Append("s_PubNo=@s_PubNo,");
strSql.Append("dt_PubDate=@dt_PubDate,");
strSql.Append("s_PubVolume=@s_PubVolume,");
strSql.Append("s_PubGazette=@s_PubGazette,");
strSql.Append("s_PubClass1=@s_PubClass1,");
strSql.Append("s_PubClass2=@s_PubClass2,");
strSql.Append("dt_SubstantiveExamDate=@dt_SubstantiveExamDate,");
strSql.Append("s_IssuedPubNo=@s_IssuedPubNo,");
strSql.Append("dt_IssuedPubDate=@dt_IssuedPubDate,");
strSql.Append("s_IssuedPubVolume=@s_IssuedPubVolume,");
strSql.Append("s_IssuedPubGazette=@s_IssuedPubGazette,");
strSql.Append("s_IssuedPubClass1=@s_IssuedPubClass1,");
strSql.Append("s_IssuedPubClass2=@s_IssuedPubClass2,");
strSql.Append("s_CertfNo=@s_CertfNo,");
strSql.Append("dt_CertfDate=@dt_CertfDate,");
strSql.Append("s_PCTAppNo=@s_PCTAppNo,");
strSql.Append("dt_PctAppDate=@dt_PctAppDate,");
strSql.Append("s_PCTPubNo=@s_PCTPubNo,");
strSql.Append("dt_PctPubDate=@dt_PctPubDate,");
strSql.Append("dt_PctInNationDate=@dt_PctInNationDate,");
strSql.Append("n_PCTPubLan=@n_PCTPubLan,");
strSql.Append("n_ManualPages=@n_ManualPages,");
strSql.Append("n_ProtectionDuration=@n_ProtectionDuration,");
strSql.Append("dt_ExpirationDate=@dt_ExpirationDate,");
strSql.Append("s_PCTSearchBureau=@s_PCTSearchBureau,");
strSql.Append("dt_FirstCheckDate=@dt_FirstCheckDate,");
strSql.Append("s_ReviewNo=@s_ReviewNo");
strSql.Append(" where n_ID=@n_ID");
SqlParameter[] parameters =
{
new SqlParameter("@s_AppNo", SqlDbType.NVarChar, 50),
new SqlParameter("@dt_AppDate", SqlDbType.DateTime),
new SqlParameter("@n_ClaimCount", SqlDbType.Int, 4),
new SqlParameter("@s_PubNo", SqlDbType.NVarChar, 50),
new SqlParameter("@dt_PubDate", SqlDbType.DateTime),
new SqlParameter("@s_PubVolume", SqlDbType.NVarChar, 50),
new SqlParameter("@s_PubGazette", SqlDbType.NVarChar, 50),
new SqlParameter("@s_PubClass1", SqlDbType.NVarChar, 50),
new SqlParameter("@s_PubClass2", SqlDbType.NVarChar, 50),
new SqlParameter("@dt_SubstantiveExamDate", SqlDbType.DateTime),
new SqlParameter("@s_IssuedPubNo", SqlDbType.NVarChar, 50),
new SqlParameter("@dt_IssuedPubDate", SqlDbType.DateTime),
new SqlParameter("@s_IssuedPubVolume", SqlDbType.NVarChar, 50),
new SqlParameter("@s_IssuedPubGazette", SqlDbType.NVarChar, 50),
new SqlParameter("@s_IssuedPubClass1", SqlDbType.NVarChar, 50),
new SqlParameter("@s_IssuedPubClass2", SqlDbType.NVarChar, 50),
new SqlParameter("@s_CertfNo", SqlDbType.NVarChar, 50),
new SqlParameter("@dt_CertfDate", SqlDbType.DateTime),
new SqlParameter("@s_PCTAppNo", SqlDbType.NVarChar, 50),
new SqlParameter("@dt_PctAppDate", SqlDbType.DateTime),
new SqlParameter("@s_PCTPubNo", SqlDbType.NVarChar, 50),
new SqlParameter("@dt_PctPubDate", SqlDbType.DateTime),
new SqlParameter("@dt_PctInNationDate", SqlDbType.DateTime),
new SqlParameter("@n_PCTPubLan", SqlDbType.Int, 4),
new SqlParameter("@n_ManualPages", SqlDbType.Int, 4),
new SqlParameter("@n_ProtectionDuration", SqlDbType.Decimal, 9),
new SqlParameter("@dt_ExpirationDate", SqlDbType.DateTime),
new SqlParameter("@s_PCTSearchBureau", SqlDbType.NVarChar, 200),
new SqlParameter("@dt_FirstCheckDate", SqlDbType.DateTime),
new SqlParameter("@s_ReviewNo", SqlDbType.NVarChar, 50),
new SqlParameter("@n_ID", SqlDbType.Int, 4)
};
parameters[0].Value = model.s_AppNo;
parameters[1].Value = model.dt_AppDate;
parameters[2].Value = model.n_ClaimCount;
parameters[3].Value = model.s_PubNo;
parameters[4].Value = model.dt_PubDate;
parameters[5].Value = model.s_PubVolume;
parameters[6].Value = model.s_PubGazette;
parameters[7].Value = model.s_PubClass1;
parameters[8].Value = model.s_PubClass2;
parameters[9].Value = model.dt_SubstantiveExamDate;
parameters[10].Value = model.s_IssuedPubNo;
parameters[11].Value = model.dt_IssuedPubDate;
parameters[12].Value = model.s_IssuedPubVolume;
parameters[13].Value = model.s_IssuedPubGazette;
parameters[14].Value = model.s_IssuedPubClass1;
parameters[15].Value = model.s_IssuedPubClass2;
parameters[16].Value = model.s_CertfNo;
parameters[17].Value = model.dt_CertfDate;
parameters[18].Value = model.s_PCTAppNo;
parameters[19].Value = model.dt_PctAppDate;
parameters[20].Value = model.s_PCTPubNo;
parameters[21].Value = model.dt_PctPubDate;
parameters[22].Value = model.dt_PctInNationDate;
parameters[23].Value = model.n_PCTPubLan;
parameters[24].Value = model.n_ManualPages;
parameters[25].Value = model.n_ProtectionDuration;
parameters[26].Value = model.dt_ExpirationDate;
parameters[27].Value = model.s_PCTSearchBureau;
parameters[28].Value = model.dt_FirstCheckDate;
parameters[29].Value = model.s_ReviewNo;
parameters[30].Value = model.n_ID;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
