public bool UpdatePhotosList(string deluidstr, string changeuidstr)
{
if ((changeuidstr == "") && (deluidstr == ""))
{
return(true);
}
StringBuilder builder = new StringBuilder();
if (deluidstr != "")
{
builder.Append(" delete from PT_PrjInfo_PhotoList where uid in (" + deluidstr + ") ;");
builder.Append(" delete from XPM_Basic_Thumbnai where ThumbnaiCode in (" + deluidstr + ") ; ");
}
if (changeuidstr != "")
{
builder.Append(" update PT_PrjInfo_PhotoList set IsValid='1' where uid in (" + changeuidstr + ")");
}
return(publicDbOpClass.ExecSqlString(PrjInfo_Action.GetTranscationStr(builder.ToString())) > 0);
}
public int DelAllPhotosPrj(string prjguid)
{
string sql = " DELETE FROM PT_PrjInfo_PhotoList WHERE PrjGuid=@uid; DELETE FROM XPM_Basic_Thumbnai WHERE ThumbnaiCode IN (SELECT ppipl.UID FROM PT_PrjInfo_PhotoList ppipl WHERE ppipl.PrjGuid=@uid)";
return(publicDbOpClass.ExecuteNonQuery(CommandType.Text, PrjInfo_Action.GetTranscationStr(sql), new SqlParameter[] { new SqlParameter("@uid", prjguid) }));
}
public int DelAllPhotos(string uid)
{
string sql = " delete from PT_PrjInfo_PhotoList where uid in (@uid) ;delete from XPM_Basic_Thumbnai where ThumbnaiCode in (@uid)";
return(publicDbOpClass.ExecuteNonQuery(CommandType.Text, PrjInfo_Action.GetTranscationStr(sql), new SqlParameter[] { new SqlParameter("@uid", uid) }));
}
