public static int currentPeriod(int p)
{
int cd = 0;
using (Multek.SqlDB sqldb = new Multek.SqlDB(__conn))
{
string sql = "sp_currentPeriodAdd";
SqlCommand cmd = new SqlCommand(sql);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@addNumber", -1);
cd = Convert.ToInt32(sqldb.getSignalValueCmd(ref cmd));
cmd.Dispose();
}
return cd;
}
public static bool isCEMSales(string uid)
{
bool yes = false;
using (Multek.SqlDB sqldb = new Multek.SqlDB(__conn))
{
SqlCommand cmd = new SqlCommand("[sp_gam_isCEM_sales]");
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@usrid", uid);
yes = Convert.ToBoolean(sqldb.getSignalValueCmd(ref cmd));
cmd.Dispose();
}
return yes;
}
public static string submit_finish_forecase_get(int salesman_id)
{
string ls = "";
string sql = "select top 1 submit_time from gam_salesman_submit where sales_id= @salesman_id order by submit_time desc";
using (Multek.SqlDB sqldb = new Multek.SqlDB(__conn))
{
SqlCommand cmd = new SqlCommand(sql);
cmd.CommandType = CommandType.Text;
cmd.Parameters.AddWithValue("@salesman_id", salesman_id);
object o = sqldb.getSignalValueCmd(ref cmd);
cmd.Dispose();
if (o != null)
ls = Convert.ToDateTime(o).ToString("d MMM,yyyy h:mm tt");//.ToShortDateString();
}
return ls;
}
